Can a table be copied intotal to use for viewing

  • Thread starter Thread starter TES
  • Start date Start date
T

TES

In Access 2007, is there a way to product a copy of a table to another tab on
the left such that it can be viewed, but not changed? This would be a back
door way of locking the table if the original tab is hidden, and forcing the
used to enter data using a form.

Thanks
 
Users should never be allowed to work directly with tables. They should have
access only to forms. Hidding a table in a tab is not the answer. A good
user interface and some level of security should be implemented.
 
I'm with Dave ... Access tables may LOOK like spreadsheets, but they are
NOT. Giving your users 'access' to tables, even copies of tables, does them
a great disservice.

Use Access forms to display data.

You appear to be trying to accomplish something, perhaps to give users a way
to look at their data.

But if your data is well-normalized, most (normal) users won't be able to
comprehend the underlying (well-normalized) data structure. Instead,
consider creating a query that joins together the (well-normalized) tables
to present a view that users would more likely understand. Plus, you can
control the query so that the users cannot update the underlying table
entries.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top