Lock users out of table, but still access data?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have many forms built that my users should utilize to change records in
our database. There are edits and rules built into these forms. A few of
my users are Access-savvy and have figured out that they can simply open the
table and directly make changes to records. If I lock them out of the
table, then they can't read and write the records.

Is there some way I can restrict them from opening the table, but still
allow them to access the data in the table through forms and queries?

Thanks for your help!

Rick
 
Go to Tools, Startup and un-check "Display database window"
Specify a form in the "Display Form/Page:" input field.
 
That won't work in this case. My users need to be able to get to all the
forms and queries and reports. Also, couldn't they simply hold down shift
while signing on, or press F11 to bring up the window?

Rick
 
Back
Top