Split database only allowing one user at a time

[Zaeed]

Ok, I built a database that is to be used by multiple people across the network. I built it so that it required minimal interaction with the backend.

Im now in the testing phase, and one of the checks I did was to see how it handled when two people accessed it simultaneously. Well it didn't work at all.

When my db opens, it first throws up the hourglass, then proceeds to relink to the backend tables. Once this is complete it proceeds to the login form.

So, if a user has the db already open, and somebody else trys to open it, the database hangs on the hourglass. Thus i'm assuming that it has something to do with relinking the tables.

Any ideas?

 

[boblarson]

And you have a copy of the frontend on each users computer (not sharing a file from the server)?

 

[Zaeed]

correct. The users can launch the database fine, except in the case where somebody else already has it open.

 

[DCrake]

Why are you relinking the tables each time you open the mdb? If you reason is valid then for testing purposes turn the relink option off then get two users to open the mdb at the same time. Working on the principle that the relink has worked.

If everything goes ok then this intimates that the relink process is at fault. Also check that you have not set the database to be opend exclusively.

Go to Tools > Options > Advanced and check the Default open mode

David