We help IT Professionals succeed at work.

Access 2010 linked tables to sql server will not open on another users machine remote

Fordraiders
Fordraiders asked
on
access 2010
sql server 2008 r2

I have on my machine an access database, that i can open liked tables just fine.

When i put the database on another user..
The program will work, but I cant open the linked tables ?

Thanks
fordraiders
Comment
Watch Question

John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019

Commented:
You probably missed the DSN...Control Panel --> Administrative Tools --> ODBC Data Source Administrator (Probably 32 bit -- i you are missing it -->syswow64\odbcad32.exe) -- User or System DSN
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
Actually, you are far better off using DSN-less connections.

You could also have an issue with the other computer not having the appropriate SQL Server driver installed.
John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019

Commented:
There is a mention for linked tables....even there is the trickery for DSN-less there is the need for correctly setting up the connection 1st time...

Author

Commented:
ok weird, the table will OPEN when i right click  ,,,,and select "Open"....but not when i double-click ??
Software & Systems Engineer
Distinguished Expert 2019
Commented:
Well the obvious thing is to check your mouse double click speed...if that doesn't helps then i guess its time to uninstall Access and reinstall it...

Author

Commented:
thanks