ShawnGray
asked on
MSAccess ODBC
I started creating an ODBC connection from inside Access 2003 to SQL 2008. Now I want to remove it but its not listed in my ODBC sources; only in Access. (see attached)
How can I remove this from Access?
How can I remove this from Access?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I should add to that a bit; Access doesn't store DSN information in it. The dialog you see inside Access is a call the OS; it's not part of Access.
Access stores a reference to the DSN (if used) as part of a tables properties (the .Connect property).
This property also tells Access which tables are linked, local, what type, etc and how to get to them.
Jim.
Access stores a reference to the DSN (if used) as part of a tables properties (the .Connect property).
This property also tells Access which tables are linked, local, what type, etc and how to get to them.
Jim.
ASKER
Jim,
Thank you. thats exactly what I was doing wrong.
Really appreciate the help and the explanation.
Shawn
Thank you. thats exactly what I was doing wrong.
Really appreciate the help and the explanation.
Shawn
ASKER
ODBC.pdf