Use ADO in Access 2000?

C

Chris Nebinger

Close the DB and reopen it.

If you make any design changes it is possible that you
will lock the database.


Chris Nebinger


-----Original Message-----
This seems so simple, yet I can't seem to work it out.
I have an Access 2000 database open.
I want to connect to the database and append to a table using ADO.
When I try to open the ADO Connection, I get the error
Click to expand...
message 'The database has been placed in a state by
user 'Admin' on machine 'MYMACHINE' that prevents it from
being opened or locked.'
I experimented with the Mode settings of the Connection object to no avail.
I have a reference set to the ADO 2.8 library, no DAO
Click to expand...
reference - I'd like to avoid DAO.
 
Top