[AccessD] Linking to SQL Server table from Access - desired table does not show in list

Michael Mattys michael at mattysconsulting.com
Sat Dec 14 19:50:30 CST 2013


Hi Guss,

Sounds like your default database is Master and you want a different one in
the ODBC Link Wizard.

Michael R Mattys
Mattys Consulting, LLC
www.mattysconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Guss Ginsburg
Sent: Saturday, December 14, 2013 11:02 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Linking to SQL Server table from Access - desired table
does not show in list

i imported the table into SQL Server, and it shows up on my computer in the
database, but when i try to link to it, the list of tables that comes up are
only system tables, and the data i am looking for is not shown. Did i leave
out a step in the process of creating the db or importing the file?  

 

Sincerely yours,

 

Guss Ginsburg

 




More information about the AccessD mailing list