.mde file preventing multi access

[jadeverell]

Hi,
I have a .mde database which has been created in Access 2003. It is stored on a network and is accessed by up to 3 people.

Whenever a user logs into the database it creates a .ldb record locking file and only allows one user into the database at a time (i.e. if another person wants to log into it, the first person has to log out).

I didn't think the .ldb file restricted access to the whole database, only records within it.

I have tested multi access to the .mdb file and this is find, so it seems to be a problem with the .mde version.

Does anyone know how i can fix this problem as it is becoming increasingly annoying.
Many Thanks
James

 

[gemma-the-husky]

are you opening the database in exclusive mode

that will stop multiple users using the dbs

---
in any event you should split the database to front end/backend, and not share the same dbs copy between users

 

[jadeverell]

Nope. Opening it in normal mode.

JD

 

[Rabbie]

When the second user tries to access .mde are they getting an error message and if so, what is it?

 

[jadeverell]

Hi,

There is no error message, when they click on the access file it just doesn't load the database.
It has been suggested to split the database into a Front End & Back End system to allow for multi-user access.

Is this a stable method of setting up a database?

thanks

 

[Rabbie]

Hi,

There is no error message, when they click on the access file it just doesn't load the database.
It has been suggested to split the database into a Front End & Back End system to allow for multi-user access.

Is this a stable method of setting up a database?

thanks

Yes it is the reccommended way of having a multi-user db. Each use should have a copy of the FE on their own computer with the BE on a common server.