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

How do you keep users from changing reports and forms

P: n/a
What I would like to do is set my database so that the users can add,
change, and delete data on the forms and print the reports, but not modify
the forms, the reports, the table layouts, or use the datasheet to modify
tables. How do I do this?

Robert
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Robert" <pr**********@yahoo.com> wrote in
news:10*************@corp.supernews.com:
What I would like to do is set my database so that the users
can add, change, and delete data on the forms and print the
reports, but not modify the forms, the reports, the table
layouts, or use the datasheet to modify tables. How do I do
this?

Robert


Read MS's knowledgebase article on security.
Back up the entire hard disk drive.
Reread the security knowledgebase again.
Make a copy of the database you wish to secure.
Implement security on the copy.
If you mess up, restore from the backup. (repeat as necessary).
Once you have everything working to your satisfaction, repeat on
the original .mdb

Alternative, create a .mde and make them use that. keep the .mdb
safe for when you need to make changes.

Bob Q.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.