Split Database Proplem (Error 3734) Access 2000

B

Bob The B

I have a network of 3 computers. Machine 1 has an access mdb file used for
taking customers' orders which works well. I have copied the program to
machines 2 and 3, and linked these to the tables in the program on machine 1.
Sometimes this works, but I often can not enter any new records on machine 1
or 2 and get the following error message: "The database has been placed in a
state by user <Admin> on machine <Shop1> that prevents it from being opened
or locked. (Error 3734)".
Can anybody explain what's happening on machine 1 and how to stop it.
 
N

NetworkTrade

doesn't sound like you actually split it.....

sounds like you simply copied it....but this is just a guess...
 
M

Margaret RM

Hi
I have had the same problem. I don't think the splitting the database is
the problem. One workaround that seemed to help today was to go to the
Startup menu and uncheck all the options. It seems that when you allow
Toolbar/menu changes (and maybe other things) it seems to put the database in
an exclusive mode (even though it is marked shared). I don't know if that
will help - but it allowed 3 people in my application today after 2 weeks of
not being able to share.
 
Top