File Security

[Question Boy]

I have a split secured db on a server. The user has the front-end on their
local pc and the back-end and security file are located on the server.

What minimum priviledges does one need to be able to run the database
properly?

I thought security was set properly but the db won't work for a specific
user I found out that they didn't have the same permission as the rest of the
group. Now they want to set the perms. for on the db files rather than the
entire folder and asked me what to set it to. Any guidance is appreciated.

QB

 

[Arvin Meyer [MVP]]

Set them on the folder, not the file. Access must create a locking file with
the first logon (you'll see an LDB file if you look at the server) So the
user must have the Change privileges (RWXD) on the folder. That is the
highest privilege except for FullControl. If you set a Database Group up and
give the administrator FullControl, and everyone else allowed in Change,
everything will work correctly. Deny privileges to anyone else or make sure
they cannot log in first, or log off last and give them read permissions if
you want them to open forms.