Access, ODBC

[WayneDoherty]

Hi I have access to a server from my desktop. If I open Excel, Data, Get External Data, New Database Query I get asked to Choose Data Source, which is great.

But in Access, I have to go File, Get External Data, Link Tables then it wants to know where to look in. How do I get it to go to the External Data Source.

Wayne

 

[FancyPrairie]

In the File Type drop down, scroll to the bottom and select ODBC Databases