Securing Table Data

[michaelak117]

I have heard it is possible to choose certain objects in a database for security. I am interested in protecting my tables so that they cannot be edited, deleted, or changed in any way. I have heard you can use the Access Security Wizard but for some reason it does not show in my ribbon, probably because i may not be logged in as an admin. Not sure how all that works on a DB.

Im not sure, does anyone have any tips on how to set this kind of security? Thanks

 

[ezfriend]

That's an interesting topic. I know that you can create hidden tables, but haven't done secured table. I wonder if that's even possible.

 

[michaelak117]

Well I know you an apply user level security and decide who can manipulate what inside your database, but this is only existent in 2003 and earlier. I am using 2007. I guess my best bet is to rely on the security I have now--automatic imports, using forms to reduce human error and keeping everything hidden. I dont know I just wish there was a way to allow a table to take daily imports but protect users from accidenty changing, i would make me feel better.