K
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.
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.