Lock one table with password

  • Thread starter Thread starter eeshat
  • Start date Start date
E

eeshat

How can I lock just one table with password protection from other
users. It is OK if other users read the data, but they should not be
able to modify the content of the table, even if they use a form.
Several users use the same MDB access data base. The database does not
have a sql server back end. I am using Access 2003.

Thanks in advance.
 
One approach might be to hide the table from view, but provide the users a
query that returns the tables' rows. If you use the Totals button, I
believe the recordset is not updateable.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
One approach might be to hide the table from view, but provide the users a
query that returns the tables' rows. If you use the Totals button, I
believe the recordset is not updateable.
Click to expand...

Or define it as a Snapshot query.
 
Back
Top