Runtime error 3734

[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?

 

[John W. Vinson]

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?

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