I have a server to which I access my data. Let's call it 190.250.65.210.
To get data from this in Access I do this:
1. Click on the "ODBC Database"-import Tab in Access
2. Then choose"SQL Sever" (from the listbox-menu) as Driver
3. And type in the Server: 190.250.65.210
4. I then press next...