Security ?

[LG]

I started out with a db that was not secure and everyone had admin rights as
a test group. Prior to it going live I split the DB to FE and BE. All works
well with securities, pass words and reports etc. The only problem I have is
1 individual's id keeps locking the records everytime he is in something. I
thought that if I had split the DB this would prevent that. I understand if
I am in as the Admin and make changes that would happen but not a user. Any
ideas why this would happen?

 

[Jerry Whittle]

Make sure that all the users have Read, Write, Create, and Delete priviliges
to the BE database file AND the entire folder where it's located.

I'm assuming at each person has their own copy of the FE. If not, do the
same as the above with the BE, or better yet, give everyone a copy of the FE
on their PC.

Lastly watch how the one person opens the database. Make sure that they
aren't opening it exclusively somehow. They should be using a shortcut and
not opening up Access first then the database file.