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

Fordraiders
Fordraiders used Ask the Experts™
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

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

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...
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
ok weird, the table will OPEN when i right click  ,,,,and select "Open"....but not when i double-click ??
Software & Systems Engineer
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial