|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 26th, 2009, 10:18 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Lock one table with password
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. 
|
|
#2
February 26th, 2009, 11:15 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Lock one table with password
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 wrote in message ... 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.
|
|
#3
February 26th, 2009, 11:55 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Lock one table with password
On Thu, 26 Feb 2009 15:15:48 -0800, "Jeff Boyce"
wrote: 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. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
