I'm using VB in Excel and need to s

[CharlesCook]

I'm using VB in Excel and need to set the path of an ODBC data source. I can see the datasource path in regedit. How can I update the registry entry? CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining

 

[StevePB]

Hi Charles,

The following URL has a load of info on this from MS:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo01/html/o2k0184.asp

I hope this helps, SteveB.

 

[CharlesCook]

Thanks for pointing me over to MS. The problem with using the command in the article is it uses one special access user branch of the reg.

But you got me pointed in the right direction. This seems to work for ODBC.

x = "DBQ=C:\x.mdb"

DBEngine.RegisterDatabase "Forecast","Microsoft Access Driver (*.mdb)",True,x

You can read more at:

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D2/S5A2EA.asp

Thanks again.... CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining