If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can a table be copied intotal to use for viewing
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 |
#2
|
|||
|
|||
Can a table be copied intotal to use for viewing
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. -- Dave Hargis, Microsoft Access MVP "TES" wrote: 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 |
#3
|
|||
|
|||
Can a table be copied intotal to use for viewing
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 "TES" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|