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

Randy Anthony randall.anthony at cox.net
Sat Dec 14 10:49:29 CST 2013


Guss,
Are you importing/viewing the data via SSMS?  Then when you open Access and
try to link you can't see the tables to pick from?  If so, you need to add
permissions to the SQL side so that your ODBC connection will allow you to
see/select the tables.

-----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