Can a table be copied intotal to use for viewing

[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

 

[Klatuu]

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.

 

[Jeff Boyce]

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