Access 2013 Databae Backend protection - Microsoft Community

i created access database application sp.  have backend (be) file in share file server.  frontend (fe) used multiple users.

i gave copy of frontend application users place on desktop. 

i restrict access of users backend file is.   windows security set users @ file level - have read/write permission file.  no directory level security.  

the issue have lockfile (laccdb) created when first user starts backend file @ there computer - other users readonly access database.

if open backend database , lockfile created in that directory users have filelevel access folder , working. application running in foreground hole time.

in access can schedule in windows open database (backend db) create lock file  and runs in background , till scheduled shutdown.

regards,

anusm

users not need open end file, copy of front end, via data in end tables accessed virtue of linked tabledef objects in front end.  users each able update data in end unless 2 users attempt edit same record simultaneously, , pessimistic locking strategy has been adopted, in case record not updatable second user until first user has completed updates , saved record, releasing lock.

optimistic locking strategy has been adopted 2 users able edit same record simultaneously, 1 user informed user has edited same record in meantime when try save record.  given opportunity see other user's edits, , can opt overwrite them or abort own edits.

Office / Access / Microsoft Office Programming / Office 2013