Changing connection details

[Nocky35]

Hi, I am currently having to change a number of connection details fo
queries, I need to have some VBA code that I can run macros to find th
existing connection details, and change them to the new one
automatically, without me having to recreate the queries.

Can anyone help?

Cheer

 

[Tom Ogilvy]

if querytables, then check the connection property. You would have to parse
the string and make the changes, then assign it back.

 

[Nocky35]

Hi, i've managed to get it to change everything, but I only want it t
change the DSN, UID and DBQ.

If someone knows how to just display the dsn part of the connectio
property, then I can work it out from there...

Anyone got any ideas on what the rest does?

ODBC;DSN=###;UID=###;;DBQ=###;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F;CSR=F;FWC=F;PFC=10;TLO=0