Protect tables? ACCESS2007 w/ *mdb Database

[KGlennC]

Developed database w/ACCESS 2003 that is just now going live (Chain
Sales.mdb)... Installed ACCESS 2007.

Database is very simple.. One (1) input menu selection item with main data
table and five (5) other tables (e.g, Item, Product, Class, etc.), each with
a Maintenance button that allows changes to those five tables (Add, Delete,
etc.).

I have a Main Menu form where User can select "Data Input" or "Reports", as
well as "Maintenance" for the five (5) base tables.

I want to protect any of the base tables from being modified. In other
words, I don't want anyone being able to add/delete Items, Product, Class,
etc.... only input product sales and costs into the main table.

Can I protect a specific table from being modified? How?

Would the answer change if I converted the dataase from ACCESS2003 to
ACCESS2007?

Hopefully, this information is clear enough. If not, I'll provide more
information needed.

 

[Jerry Whittle]

The answer would certainly change if you convert from the older .mdb file
format to the newer Access 2007 accdb format. You couldn't do it. The accdb
database format does not support user-level security which is what you need
to do what you want.

User level security is a lot of work to set up and maintain. The first
question to ask yourself is do you REALLY, REALLY need it. Can't you trust
your users instead? What bad would happen if someone messed with a record? If
you still think that you need to protect the tables, check out the following:

http://office.microsoft.com/en-us/access/HP030704101033.aspx