ADO .Open problem (posted on general news too)
Hi Jack
The problem is because you have the database open, I
suggest that you close the database and try again, or you
could try opening the database in "shared" mode. Check
the default opening mode
under "Tools";"Options";"Advanced" and select "Shared"
HTH
Paul
Quote:
>-----Original Message-----
>I am trying to open a database using ADO using the
>following .Connectionstring:
>"Provider=Microsoft.Jet.OLEDB.4.0;Data
>source=d:\user\jack\temp\dbTest.mdb"
>The database is one that I have designed and resides on
my
>local machine.
>The call to use the ADO object is made from a VBA module
>within the database itself (i.e. the database is already
>open when the connection is being made)
>I get the following error message:
>"The database has been placed in a state by user 'Admin'
>on machine 'COMP195' that prevents it from being opened
or
>locked."
>How do I either modify the permissions of the database,
or
>the connection type, to avoid this issue?
>Thanks
>Jack.
>.
