Use ADO in Access 2000?

[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

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

reference - I'd like to avoid DAO.