cant connect

G

Guest

Hi,
I get following message:

The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked. (Error 3734)

when I try to connect to my db from another computer.
What should I do?
thanx

alekm
 
W

Wayne Morgan

Verify that no one is using the database then look in the database's folder
for an *.ldb file with the same name as the mde or mdb file. If it is there,
delete it and try again. If that still doesn't work, try copying the
database to your computer and see if you can open it from there.

If you still can't open the file, then there is probably something
corrupted. Follow these links for things to try.

http://members.iinet.net.au/~allenbrowne/ser-47.html
http://members.iinet.net.au/~allenbrowne/ser-25.html

If you are going to run a database across the network, you really need to
split it into a front-end and back-end. You are asking for corruption if you
don't. The front-end will contain all the forms, queries, reports, temporary
tables, etc and a copy of it should be placed on each user's computer. The
back-end should contain just the tables that hold the data. Create links to
these tables in the front-end file.

--
Wayne Morgan
Microsoft Access MVP


alekm said:
Hi,
I get following message:

The database has been placed in a state by user <name> on machine <name>
that prevents it from being opened or locked. (Error 3734)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top