Lockout Issues

[mjn015]

I’ve made several changes to my database based on suggestions from this Forum. As someone just getting their feet wet with Access, you guys are an invaluable resource. The experience and knowledge displayed in reading these different threads is impressive. But more importantly, the willingness of everyone to help us newbies out is very much appreciated.

My users are experiencing lock outs when several of them are in the db entering data from a Form at the same time. Here’s my situation: I have a database that I’ve split. The BE is in a folder on a networked server. The FE was distributed to several users. These users have Read, Write, Execute, Modify NTFS permissions on the folder where the BE resides. MS Access Security was never set up for this db.

I’m not sure why we’re experiencing these lockouts. Is it because we don’t have Access Security set up yet? I keep looking at the LDB file as possibly playing a role in this issue. I see that the file is created when the db is open by a user and I can see several Computer Names in there. I’ve noticed that even though I would exit from the db, my computer name is still in the LDB file along with the several other users who, I’m assuming, are still in the db. Shouldn’t my computer name be removed automatically when I exit the database?

I’ve searched a number of threads on lockout issues in this Forum and I think I’ve grown numb to my own issue from reading all of them. I guess I’m just thinking out loud in the hopes that someone out there will have a “magic bullet” for me.

Thanks in advance for everyone's help/suggestions...
Michael

 

[Rabbie]

They need to have Delete permission as well so they can delete the .ldb file that controls record access

 

[mjn015]

Thanks Rabbie. I was under the impression that Modify access allowed them to delete, make changes, or rename the file.

 

[Rabbie]

I am not sure if it includes Delete. Anyhow the .ldb file should not be there if no-one is using the DB and that is the file that implements the record locks. Also check the Options set on the Advanced tab for default record locking. Edited record is probably what you need.

 

[mjn015]

I will check with the network folks to confirm the delete permission. The default record locking is set to Edited Record.

 

[mjn015]

I'm still grappling with ldb file and it's need for users to have FULL permissions to the folder where it resides. It seems to me that you can lock down the database using Access Security, but because users require full permissions to the folder where the db resides so the ldb file can work properly, they have the ability to delete the entire database. Am I missing something here?