• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1069
  • Last Modified:

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?
0
ShawnGray
Asked:
ShawnGray
  • 2
  • 2
1 Solution
 
ShawnGrayAuthor Commented:
Attached
ODBC.pdf
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Make sure outside of Access that your using the right ODBC admin tool.  You want to use the 32 bit version of the tool, which is:

%systemdrive%\Windows\SysWoW64\Odbcad32.exe

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.
0
 
ShawnGrayAuthor Commented:
Jim,
Thank you.  thats exactly what I was doing wrong.
Really appreciate the help and the explanation.
Shawn
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now