[dba-SQLServer] Link odbc tables in Access

Arthur Fuller fuller.artful at gmail.com
Mon Jul 25 16:42:45 CDT 2011


They are all views into the meta-data of the database, intended to insulate
you from relying on the structure of tables such as SysColumns. As to how to
hide them, I have no idea. But if you create an ADP, you don't see them. So
why don't you do that instead? Just a question; you may have some valid
reason for going the DSN route.

A.

On Mon, Jul 25, 2011 at 2:57 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> When I link to SQL Server from Access using a DSN file, I end up with my
> tables displayed but also about a billion (sorry, I didn't count) tables
> that start with INFORMATION_SCHEMA_.xyz.  At this time I have no use for
> those tables and would like to filter them out so that I cannot see them.
> Does anyone know how to do that?
>



More information about the dba-SQLServer mailing list