Greetings,

I recently set up a machine data source in Access so that I could link to tables in a MySQL installation. After setting up the machine data source with test settings, I would like to remove it. However, there are no delete or edit options when selecting a machine datasource in Access for linking tables.

Does anyone know how I can go about deleting the machine data source? I believe I read that it is stored in the registry, so I am guessing that may be where I need to go.

You can go to Control Panel and modify the existing data source to point to the new one. However, it should be MySQL I am thinking.

If the database is using the DSN, it is just a pointer and will take whatever connection information is there when it accesses it by name.



mmcdonal

Here is the code to write a SQL Server DSN from VBA or vbs:

Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\DSNName\Database" , "DatabaseName"
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\DSNName\Driver", "C:\Windows\System32\\SQLSRV32.dll"
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\DSNName\LastUser" , "DefaultUserName"
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\DSNName\Server", "S_SQLServerName"
WshShell.RegWrite "HKLM\Software\ODBC\ODBC.INI\ODBC Data Sources\DSNName", "SQL Server"

So this should give you an ideea of where to look in the registry.


mmcdonal

Thank you for the help. I have been able to find the entries in the registry.