Lock a front-end access database -


i've split database , have 2 front end versions. 1 version data entry , 1 version end-users run own queries. there way "lock" query version end-users cannot accidentally change data queries run? i.e., want them able run select queries , make table queries. don't want them able edit of data end file.

you can set queries snapshots, distinct, or aggregating.

but not 100% safe, indeed not if have access linked tables.

to safe, move database sql server (express version free) , create read-only user account.


Comments