I'd like to delete/remove some Machine Data Sources (DSN) I used while
testing out SQL Express. I've tried to google it but I can't seem to find
anything on how to remove them once they've been added. I checked the
registry but, again, I couldn't really find where Access is storing the lists
of DSNs.

Any ideas on how to manually remove them? No code, please, I'm hoping I can
just manually remove entries from some file or the registry.

Thanks in advance.

Machine Data Sources should be under HKLM\Software\ODBC\ODBC.INI

User Data Sources should be under HKCU\Software\ODBC\ODBC.INI

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"snooka9" <snooka9@discussions.microsoft.com> wrote in message
news:607E7B5D-8A4F-485E-8120-B934318B99BC@microsoft.com...
> I'd like to delete/remove some Machine Data Sources (DSN) I used while
> testing out SQL Express. I've tried to google it but I can't seem to find
> anything on how to remove them once they've been added. I checked the
> registry but, again, I couldn't really find where Access is storing the
> lists
> of DSNs.
>
> Any ideas on how to manually remove them? No code, please, I'm hoping I
> can
> just manually remove entries from some file or the registry.
>
> Thanks in advance.
>

Access doesn't store this info, Windows does. On Windows 2K and XP: Control
panel > administrative tools > data sources (odbc). On each tab (user dsn,
system dsn, file dsn), highlight the dsn you don't want and click on the
"Remove" button.

Chris
Microsoft MVP


snooka9 wrote:
>I'd like to delete/remove some Machine Data Sources (DSN) I used while
>testing out SQL Express. I've tried to google it but I can't seem to find
>anything on how to remove them once they've been added. I checked the
>registry but, again, I couldn't really find where Access is storing the lists
>of DSNs.
>
>Any ideas on how to manually remove them?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1