Table Security

[e_lady]

I am working in Access 2000. There is a table in the database that is maintained by two employees. All other employees should only be able to view and query the table. Is there a way to do that without having them log into Access?

 

[ColinEssex]

People will need to log in to see table.

Incidentally, you refer to "table", I presume you mean a form and not the actual table. If you have a form, you can then use the usernames to include / exclude them from doing things to the table via the form.

Don't forget you should always have a query behind the form not the actual table.

Col

 

[e_lady]

I actually did mean table. The employees update the table, no form. Is there a way to grant permissions to a table?

 

[ColinEssex]

Sorry, you should never allow users to access the actual table. You should always have a form and then you can tighten everything up from there.

Tables are too inflexible. Thats why you have a query behind the from drawing the data from the linked tables so data isn't repeated and also the filters, and restrictions can be done there.

Col

 

[wilko]

People will need to log in to see table.

Incidentally, you refer to "table", I presume you mean a form and not the actual table. If you have a form, you can then use the usernames to include / exclude them from doing things to the table via the form.

Don't forget you should always have a query behind the form not the actual table.

Col

Hi Collin

Just wondered why you suggest that you should always have a query benhind a form, not a table? I am currently building a database and have a built forms based on one or two tables, however not on queries, should I be?

 

[ColinEssex]

You use queries as they are more flexible, they allow you to use many tables for the form and you can control filtering much more easily.

Col