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

Mike Tope mike.tope at virginmedia.com
Sat Dec 14 10:25:13 CST 2013


Does Access see it now as dbo_tablename?
If it's any other schema you'll have to GRANT SELECT as well.
Mike Tope

----- Original Message ----- 
From: "Guss Ginsburg" <guss at beechnutconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, December 14, 2013 4:02 PM
Subject: [AccessD] Linking to SQL Server table from Access - desired 
tabledoes 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
>
>
>
>


--------------------------------------------------------------------------------


> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



More information about the AccessD mailing list