468,766 Members | 1,295 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,766 developers. It's quick & easy.

How to delete or edit a Machine Data Source type DSN from the ODBC Select Data Source window.

MLH
Am using A97. Have defined Machine Data Source type DSNs
in Access' File, Get External Data, Link Tables, Files of Type ODBC,
Machine Data Source tab. Have many definitions. Would like to
delete some. Would like to edit some.

How to delete? I don't think editing is possible.
Jan 16 '08 #1
2 16935
MLH <CR**@NorthState.netwrote:
>Am using A97. Have defined Machine Data Source type DSNs
in Access' File, Get External Data, Link Tables, Files of Type ODBC,
Machine Data Source tab. Have many definitions. Would like to
delete some. Would like to edit some.

How to delete? I don't think editing is possible.
Not sure about your exact answer but consider going DSN less.

I much prefer DSN-Less connections as it is one less thing for someone to have to
configure and one less thing for the users to screw up. This is also better for
Citrix/TS farms where each individual system would have to have a DSN created and
maintained.

Using DSN-Less Connections
http://www.accessmvp.com/djsteele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafa...m&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.carlprothman.net/Default.aspx?tabid=81
Relink ODBC tables from code
http://www.mvps.org/access/tables/tbl0010.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jan 16 '08 #2
On Tue, 15 Jan 2008 20:47:26 -0500, MLH <CR**@NorthState.netwrote:

Control Panel Administrative Tools ODBC "Remove" button.
-Tom.

>Am using A97. Have defined Machine Data Source type DSNs
in Access' File, Get External Data, Link Tables, Files of Type ODBC,
Machine Data Source tab. Have many definitions. Would like to
delete some. Would like to edit some.

How to delete? I don't think editing is possible.
Jan 16 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Steve Bishop | last post: by
3 posts views Thread by zdrakec | last post: by
2 posts views Thread by William LaMartin | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.