Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

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

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
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

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
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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...
Avatar of Fordraiders

ASKER

ok weird, the table will OPEN when i right click  ,,,,and select "Open"....but not when i double-click ??
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks