how to set a table to read only?

[Gustavson]

I'm using Access97. I have a table with a number of different fields. This table will be on a network for others to see. Anyways, I want everyone else to have read only access. How do I do this?

Thanx
Gustavson

 

[lewatkin]

Hi,

There are a number of ways to do this. Probably the simplest is to put the database in a folder on the network that is read only to everyone but whomever needs to update it. You could use User Level Security to give members of a "Read Only" group read only access to the database, or you could display the results of the table in a form set to datasheet view and allowedits, allowdeletions, and allowadditions on the form properties set to false.

Hope this helps.
Lee

 

[Gustavson]

Lee - I thought about doing the form thing but can't the table still be changed?? I'm not the administrator so the create new group button isn't available... Do I need the administrator to come in and add a group and then set group-level security?
Thanx
Gustavson

 

[lewatkin]

Gustavson,

I hate to tell you to secure your database if the users just need to see the information in one table. Access security can be cumbersome to deal with.

With or without access security, you can still disable the shift key bypass at startup, then put the users in a form with the above properties set to No (False). The data cannot be touched then. If you put the data in a form and allow users access to the database window, then yes, they can change the table - Data AND structure!

My suggestion to you - and this is based only on the fact that you said that you need users to view information in a table - place the database in a Read Only folder on your network. The only person that should have authority to make changes to the data in the database is the one that keeps it updated. Everyone else will be able to open the database, use the data, but cannot change a thing.

Hope this helps!

Lee