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.
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.
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/datafast/GetFile.aspx?file=ODB CTutor01.htm&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/
On Tue, 15 Jan 2008 20:47:26 -0500, MLH
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.