Borge Hansen
pcs.accessd at gmail.com
Sun Jul 31 08:38:02 CDT 2011
John, How about defining all your tables that you want to link to in your SQL Db in a hidden local table in your frontend and then use some vba re-linker code that travels all the records (table names) in the local table and drops and re-links the SQL Db tables. Then you can forget about the one billion other tables. And using the re-linker code you can link directly to tables in the SQL Db removing the "dbo_" prefix....which may be of benefit if you have a lot of queries that reference tables from back when they perhaps lived as access .mdb backend tables.... Just a suggestion. Regards Borge On Tue, Jul 26, 2011 at 2:57 AM, 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? > > -- > John W. Colby > www.ColbyConsulting.com <http://www.colbyconsulting.com/> > ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com/> > >