database prevented from being opened or locked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,
I am testing a routine in ms access 2000 that will post to a database table
information on a form. There is a line of instruction in the routine I
created that opens the connection like that:
dim cnn as adodb.connection
set cnn = new adodb.connection
cnn.open currentproject.connection
The routine hung on the last line of instruction shown above and displays
the message:
"The database has been placed in a state by user 'Admin' on
machine 'server01' that prevents it from being opened or
locked"
I have no clue what that refers to. I checked both the folder and the ms
access file to see if the readonly property is checked, but it is not. Please
help!!
 
It appears that user Admin has the database open in Exclusive mode. If not,
this will sometimes happen if the ldb file gets left after an improper
shutdown of Access. To determine if this is the problem, make sure no one
has the database open. Check the databases's directory for an ldb file that
has the same name as the database file. If the ldb files exists and no one
has the database open, delete the ldb file.
 
Back
Top