Runtime error 3734

  • Thread starter Thread starter Ilya Shambat
  • Start date Start date
I

Ilya Shambat

I've been trying to run a Visual Basic code for an Access database,
and I get this error:

Run-time error '3734':

The database has been placed in a state by user 'Admin' on machine
'USER-PC' that prevents it from being opened or locked.

Does anyone know what I need to do in order to get rid of this error
and be able to run the code?
 
I've been trying to run a Visual Basic code for an Access database,
and I get this error:

Run-time error '3734':

The database has been placed in a state by user 'Admin' on machine
'USER-PC' that prevents it from being opened or locked.

Does anyone know what I need to do in order to get rid of this error
and be able to run the code?
Click to expand...

First, make sure nobody else has the database open. If nobody does, see if
there is a file with a .ldb extension in the same folder as the database. If
so, delete it and try again (this file holds "locks" on simultaneous users of
the database and can be left hanging if the database isn't shut down
correctly).

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top