Locking Tables

[jschmidt]

I am working on a system that requires me to automate the import of a csv file into access and at the same time have the table locked from the user. The user should not be able to manipulate the data but they must still be able to run queries on the data and be able to run reports and the like. I am wondering what is the best way to set up the security for this. There will only be one table which will be updated monthly with new data.

So in general: How do I lock an MS Access Database table?

Any help would be appreciated!
Thanks!

[MMcCarthy]

I am working on a system that requires me to automate the import of a csv file into access and at the same time have the table locked from the user. The user should not be able to manipulate the data but they must still be able to run queries on the data and be able to run reports and the like. I am wondering what is the best way to set up the security for this. There will only be one table which will be updated monthly with new data.

So in general: How do I lock an MS Access Database table?

Any help would be appreciated!
Thanks!

The database window which lists all tables, queries, forms, etc should be hidden from the user. You can do this in startup options.

After that you can set the properties of forms used to access the data to read only.