N/APosted 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.
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.