Lock one table with password

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

 

[Jeff Boyce]

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

 

[John W. Vinson]

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.

Or define it as a Snapshot query.