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

[psuaudi]

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!

[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!

[NeoPa]

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.

[psuaudi]

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?

[NeoPa]

Look in Tools / Startup for options to restrict what an ordinary user can do.
Don't forget to leave yourself a way in.

[psuaudi]

Unfortunately, in the startup section there is nothing to prevent user access to certain areas.

[NeoPa]

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.