Locking specific fields

dgmorr

Registered User.
Local time
Today, 15:10
Joined
Jan 10, 2007
Messages
71
Hey guys,

Is there a setting that will allow me to make specific fields in my table read-only unless I enter a password, or I am the DB administrator?
 
Don't allow your users to access and/or edit tables directly. You always want them to get the table data through a form. On the form, you can lock and unlock individual fields. If you want them to have a "spreadsheet like" view, use the datasheet view on a form. The same Locked property, available for each field, exists for the standard and datasheet views of your form.
 
Thanks for the help, I've figured this out in the meantime. Now what I need to know is how to allow the user to see the forms but hide the tables. In the startup options, I have the option of only selecting one form. Anyone have an answer to this? I would like them to select from a list of forms to use.
 
Create a Switchboard Form. You can use the Switchboard Manager Utility under Tools\Database Utilities\Switchboard Manager if you have MS Office Access 2003. If not then create your own switchboard with buttons that Open the form On_Click. Make the Switchboard the default form when opening the database.

Hope that gives you a direction to go,
Goh
 
In the startup up parameters you can specify whether to open the database window ie the one that show all the tables, queries. Or you can hide any of the objects shown by right-clicking the object select properies then click hide.
 

Users who are viewing this thread

Back
Top Bottom