I'm writing this here because the Access VBA category is locked.

I'm creating a database to track report information. I created an entry form and I'm trying to use ADO to open the database and add a new record to the table. I have upgraded to MDAC 2.8.

I'm receiving the following error when I try to open the database while I'm coding in it:

  The database has been placed in a state by use 'ADMIN' on machine 'SU-FX60074' that prevents it from being opened or locked.

The help in Access has nothing on this.

The code I'm using is as follows:

    Set cnObj = New ADODB.Connection
    Set rsObj = New ADODB.Recordset


    cnObj.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=cnverrrptdesc.mdb;"

All this means is that someone else has the database open, and so it may create problems with the functions you are trying to run.

There is always a chance that this person might be you, and the operating system might not yet have cleared the lock. Look in the directory where the mdb file is kept, and see if there is an ldb file. The owner of this file is the person that has the database open. If the owner is you, ensure that you do not have the database open if you are connecting from outside the database. Alternatively, if you are trying to connect from within the database, try changing your Connection Open statement to set cnObj = Application.CurrentProject.Connection.

Hope that helps

Mike

Mike
EchoVue.com

 No, it's not locked per se. There was a redundant area for VBA questions so the moderators locked one and kept the other one open. It's located here

http://p2p.wrox.com/visual-basic-13


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks Mike. That did the trick.

Ron