I have setup an ODBC datasource, User DSN which points to a SQL server database and have tested the connection whilst in the ODBC setup (Windows>Administrator Tools) and the connection tests OK. But I can't seem to see that ODBC connection when I try to setup linked tables in Access.
I setup a blank new database, used Get External Data, Link and chose ODBC from dropdown list of file types but then nothing happens - no list of ODBC connections appears. Can someone advise what I am doing wrong please. I vaguely remember doing this a couple of years ago and it seemed to work fine on my old laptop.
I setup a blank new database, used Get External Data, Link and chose ODBC from dropdown list of file types but then nothing happens - no list of ODBC connections appears. Can someone advise what I am doing wrong please. I vaguely remember doing this a couple of years ago and it seemed to work fine on my old laptop.