MS Access - Lock backend database as Read-Only
Posted on 2004-08-16
I have a split MS Access database with the backend on a network share and the frontend on each end-user desktop.
There are no updates permitted to the backend database tables.
How can the backend database be secured as Read-Only to prevent unwanted changes and still leave the frontend completely open for the end-user to create their own forms, queries and macros ?