Hello all,
I have a front end of a database that I send out and have everyone put on their desktop. The back end is on the network in a folder that everyone has read & modify rights to. Whenever someone gets in the front end and is accessing the info from the back end, it locks everyone else out giving them an "already in use by another user" error. Why is this doing this?

Thanks!
Laura

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

__________________
Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

Hello,

Both front-end and back-end are access DB's, correct? Access generates a .ldb file which is a locking file that locks the database whenever someone accesses it. It's not transactional like SQL, where many users can access and even edit a table simultaneously.

Brian

Yes, both front end and back end are in Access XP. It is creating the lock file on the front end, which I understand, but why wouldn't it create one on the back end and let others in it at the same time? I have other databases that are not split and they create the lock file but also let multiple users in at the same time.

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

If it is not creating one on the back end side, probably you have that file set up to open exclusive by default.

Go to tools/options / advanced and make sure that it is NOt set to exclusive. the front end should be opposite if it resides on the client.



Sal

Thank you for your reply Sal,
I looked at each computer that uses this database. Each computer is set as a default to open as shared and not exclusive. This works fine on my machine. When I open the front end, it creates the lock file for both the front end and back end, but the other computers do not. We all have the same network clearance to that folder, the same default settings, & the same version of office XP, so I'm not sure why it is doing this.
Any more ideas?

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

A lock file should be present if you have set the back end properly. Make sure that the backend as well as front end is creating a lock file (actually you do not a lock file on the front end if it resides on the local PC)

Your problem is with the back end not the front end.

I do not know exactly what you mean by:

 

make sure that all datasources to all forms and reports are set to EditedRecord under recordlocks propertiy, also under options/advanced tab, make sure that under

"Default Record Locking" you ckeck Edited Record
"Default open mode" check Shared
Check the box for Opend databases using record level locking.

Do this for both front and backend.

Also, try to open a copy of your front end on another computer ansd see if it creates the lock files.





Sal

Sal,
I previously checked these settings on every computer for both the front end and back end and they were all set to the settings you mentioned.
What I meant about the lock files is that when I open the front end (which is saved to my desktop) on my PC, it creates a lock file on my desktop for the .mde file and also creates a lock file for the back end out on the network where it (the back end) is stored. When opening the .mde file on others computers, it creates the lock file for the .mde file (front end) that is located on the desktop, but doesn't create the lock file for the back end out on the network. This is what is confusing me because if mine and their setting and network clearance (on that folder)is the same, I shouldn't be having this problem.
Do you think me creating this in Office 97, then converting it to Office XP could have anything to do with it?

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

If it is because of 97 try importing items into a new DB, but I dout that that would be the problem. Even if 97 did not create lock files.

Are you sure that the back end has been converted as well? Wild guess.



Sal

Try importing all of your tables into a new access database, in case it is the 97-XP upgrade.



Sal

I imported all the tables into a new database and we are still having some issues. This is really weird...and driving me a little crazy!

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!