Is there a way to lock users out of the tables so they cant open it up and edit items, delete items or add items???

This may or may not work, and would depend on you having a network type environment, but what if you were to put all the tables in a separate DB, put that DB in a folder where the users only have read access and then link the tables into your original DB? Not sure if that will work, but it is worth a shot.

Mike

Mike
EchoVue.com

You could grant the user read only rights to the data.


Rand

well one way to prevent users from changing data in your Db is to enable the MSAccess security. You will need to create user IDs and passwords for everyone and put them into groups and grant certain rights to the groups or you can create a USER account (and have all your users use the same account) that just has read only access to the data. You could probably secure the .MDB file using the a read only permission (on the file only) but users need the ability to write to the directory the .MDB file resides. Users need to be able to write to the .LDB file that accesses uses to track users.