Split Database Proplem (Error 3734) Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob The B - 16 Nov 2006 22:10 GMT

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.

Reply to this Message

NetworkTrade - 16 Nov 2006 23:18 GMT

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

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

Signature

NTC

> 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
[quoted text clipped - 4 lines]
> or locked. (Error 3734)".
> Can anybody explain what's happening on machine 1 and how to stop it.

Reply to this Message

Margaret RM - 18 Nov 2006 00:20 GMT

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.

Reply to this Message