By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Data sharing in Access

P: 1
How can I prevent other users, with whom I share my database, from changing the records.
Feb 21 '10 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,186
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.
Feb 21 '10 #2

missinglinq
Expert 2.5K+
P: 3,532
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)>.
Feb 21 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.