Access.LockFile.9, even with Database split

[pablavo]

Hi there

I'm a bit confused with this.

I have a database which I've split and I've put both the frontend and the backend onto the network drive.

I'm pretty sure it's the case that the backend should be on the server and the copies of the frontend should be deployed to each of the computers that people are working with rather than each person working on the same frontend copy within the server. would this be right to say this?

At the moment there is two people working on the database and the third person cannot access the database because it's freezing and the 'access.lockfile.9' is showing on the third users computer for both the frontend and the backend.

Does anyone know how I can resolve this problem? is it a case of copying the frontend to each of the computers that the users are working with rather than them accessing the same frontend from the network drive.

Thankyou in advance for any help.

 

[burrcm]

You are correct. Each user should copy the front to their PC. If more than one opens the same copy of the front, it will behave the same as a single mdb.

Chris B

 

[boblarson]

Yes, copies of the frontend should be on each person's computer. Check here for a quick way to auto update those frontends:

http://www.btabdevelopment.com/main/AccessTools/tabid/78/Default.aspx

Also, the ldb file for the backend will appear when a backend is opened via a frontend even if it is linked to a frontend, so don't freak out when it does; that is normal.