Link to home
Start Free TrialLog in
Avatar of circa62
circa62

asked on

Access machine dsn vs system dsn

Can someone let me know the difference between a machine dsn which shows up in Access for connecting to one of our SQL servers vs an ODBC system dsn from control panel?
I have  a user that needs to change a machine dsn and I cannot seem to access/edit it from within Access and it doesn't show up under control panel system dsn's. Thanks
Avatar of athomsfere
athomsfere
Flag of United States of America image

Which OS and architecture?

Access will add the system DSN to whatever bit version Access is, so for Access 32bit in Windows x64 it opens the ODBCAD32.exe in C:\Windows\SysWOW64, not the one in in System32.
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
Avatar of circa62
circa62

ASKER

Windows 7 Pro 64bit, Office 2010 Pro 32bit
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
Avatar of circa62

ASKER

The connection less sounds interesting, I will look further into that. For now I think the other will help. Thanks for the quick responses!
Just to thorw in a bit; Access (VBA) is not capable of seeing all DSN types.  Within classic VB you can, but not with VBA.

The connection less string is the ticket.

For a great article on those (with code for converting), see:

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

Jim.