Home > IT Answers > Database > Hiding the system views table from Microsoft Access
SQL Server Ask the Experts
2,585 pts.
 Hiding the system views table from Microsoft Access
Microsoft Access, SQL Server database, SQL Server tables
How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

Software/Hardware used:
ASKED: January 14, 2009  5:05 PM
UPDATED: December 9, 2009  9:13 PM
RELATED QUESTIONS
Answer Wiki:
I don't know about SQL, but within Access, clicking Tools, Options, View and un-clicking System Objects in Show keeps them off the list of tables within Access itself.
Last Wiki Answer Submitted:  January 15, 2009  7:02 pm  by  tlsanders1   1,240 pts.
All Answer Wiki Contributors:  tlsanders1   1,240 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 
BadBart
 10 pts.