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

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #85678

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

qa-featured

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

 

Login/Register to Answer

Related Questions