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

Is there a way to prohibit table values from being modified unless by a form?

P: 27
I have a database that is used by several people, however, I have forms that use some vb code to change data properly.

I would like to limit the ability for certain users to change data in the tables without using forms. Is there a way to do this?

Thank you!
Jan 3 '07 #1
Share this Question
Share on Google+
6 Replies


PEB
Expert 100+
P: 1,418
PEB
Using queries and limiting the access to ur tables it can be done!

So if u create for a group of users query that is available only for them /from the mainswitchboard for exemple/ u can manage to limit the access to certain fields in ur database!

But directly using access permissions! Id on't belive that is possible!
Jan 3 '07 #2

NeoPa
Expert Mod 15k+
P: 31,660
Likewise, I believe not.
There is a possible way but it would probably involve you in a lot more work than building the forms.
Using Access Security is generally hard to implement and easy to fall over.
On balance (by a way) I would recommend to stay with the forms.
Jan 3 '07 #3

P: 27
yes, but, they will still be able to go in and modify the actual data tables in addition to being able to modify table data using a form, correct?
Jan 4 '07 #4

NeoPa
Expert Mod 15k+
P: 31,660
Look in Tools / Startup for options to restrict what an ordinary user can do.
Don't forget to leave yourself a way in.
Jan 5 '07 #5

P: 27
Unfortunately, in the startup section there is nothing to prevent user access to certain areas.
Jan 5 '07 #6

NeoPa
Expert Mod 15k+
P: 31,660
Unfortunately, in the startup section there is nothing to prevent user access to certain areas.
In Startup there is the facility to open a form automatically and there is also an option not to show the database window at all, as well as an option not to allow the user to circumvent that.
If you can't use those items to restrict access to anywhere in the database you like then I'm not sure I can help you.
Jan 5 '07 #7

Post your reply

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