Hiding the system views table from Microsoft Access

Tags:
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?
ASKED: January 14, 2009  5:05 PM
UPDATED: December 9, 2009  9:13 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BadBart
    it does not seem possible. I reviewed the following threads: http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/77f6d294-369f-4973-9020-1ef9aab5d191 http://www.developmentnow.com/g/116_2006_6_0_0_773057/How-to-hide-INFORMATION-SCHEMA-and-sys-from-users.htm http://dbaspot.com/forums/ms-sqlserver/231232-how-hide-information_schema-sys-users.html http://bugs.mysql.com/bug.php?id=17365 http://www.sqlservercentral.com/Forums/Topic671366-359-1.aspx#bm822529
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following