By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,798 Members | 1,388 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,798 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.