How can I prevent other users, with whom I share my database, from changing the records.
-
-
Making a database read only stops any access at all, so that's no use.
I would provide access to your data via forms and add a logging interface to determine whether or not it's you. If not you, then updates would be disabled. -
Or since we're talking about multiple users, you should have a split database with a front end on each users hard drive. You can simply give the people you don't want to edit data a Read-Only copy of the front end and give yourself one that can be edited.
As NeoPa said, data should always be accessed forms, and you can make form Read-Only by simply setting the form Recordset Type Property to Snapshot.
Welcome to Bytes!
Linq ;0)>.Comment
Comment