I need to remove and re-establish a Machine Data Source in Access.

  • Thread starter Thread starter Guest
  • Start date Start date
I need to remove and re-establish a Machine Data Source in Access...how?

1. Start -> Settings -> Control Panel -> Administrative Tools -> Data
Sources

You can remove your machine data source from there, reconfigure it, or
create a new one.

2. In Access, from the database window, use the tools menu to find the
Linked Table Manager. That will help you refresh your linked tables to the
correct Machine Data Source

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~
 
twolguy said:
I need to remove and re-establish a Machine Data Source in Access...how?
Click to expand...

Assuming that a Machine Data Source and DSNs are similar I'd suggest
going DSNless.

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://members.rogers.com/douglas.j.steele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.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
 
I am running Windows-7 64-Bit, so the key may be in a different location for other OS.

I found that MS Access window retains the DSN Machine names pulling them from a registry key nested deep in the HKEY_LOCAL_MACHINE.

1.) START / Search on: REGEDIT
2.) Launch the REGEDIT tool
3.) Expand to the: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI
4.) Delete the unwanted DSN named keys
5.) Open the ODBC Data Sources
6.) Delete the unwanted DSN names sub keys
7.) Close the registry editor

If you do not have the Wow6432Node key, then pick the HKEY_LOCAL_MACHINE and pick from the top drop menu EDIT / FIND and search for the specific named Machine Data Source you are wanting to delete. The location it finds should be similar and deletion process the same. I would also suggest searching the HKEY_LOCAL_MACHINE again just to be sure it has not nested somewhere else.

I hope this helps...
Cheers,
Brian
 
Back
Top