I'm very new to SQL Linked Servers so please bare with me.
I've created a Linked Server on my SQL Express Server using Visual Fox Pro drivers. Within SQL Management Studio on the server i can see the linked DB under "Server Objects-->Linked Servers-->#DB Name# an I can also run quick queries on the table within this link.
When I add a ODBC DSN on my laptop I'm unable to see the #DB Name# under the default db, if I type the #DB Name# it cannot find this. How do I link my ODBC DSN to the Linked Server on the SQL server so I can query the tables from within Access. Access can happily see the "standard" databases on the SQL server via the ODBC connection NOT the Linked Server
Hope this makes sense.