How do you hide system tables from programs like MS Access?

Asked By Vasily 0 points N/A Posted on - 01/10/2012

How do you hide system tables from programs like MS Access? Everytime I link tables in our SQL database, other system views are included in the list and I cannot find which tables I need asap.

• Status: Open
• Question Views: 932
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Mathew Stone 0 points N/A #85678

How do you hide system tables from programs like MS Access?

What always happens is that an Access system table is specially named in a manner that the first 4 characters of the table name is always called the "Usys". And therefore, in case you name the table that you are working on using the same naming convention, then you should be able to hide your table by using the Access system tables. Another thing that you will be able to achieve is use your table in forms, queries, reports, and so forth, but the only difference will be that it will not display in the database window by default.

To rename your table, you will just need to right-click on the table in the left window, and then you will select Rename from the popup menu.

After  you have done that you will need to prefix the table name with USys.

-Mathew Stone

 

About Mathew Stone

Questions
0

Answers
99

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 01/10/2012
• Question Category: MS Access