W
WebTracer
I had the code somewhere and I managed to lose it.
I wrote an access program earlier this year at my previous position,
and I used some connection info that refreshed my current ODBC links on
my computer, allowing me to switch from my Test dB to my Production dB
without having to rewrite the code. I appropriately named my ODBC
connections, and then passed Test or Prod to the code, and it switched
them around, prompting me for username and password when I changed form
one environment to the other.
I have been googling this all day, and I can't find any code that
resembles what I used.
Anyone have short, easy ODBC connect/refresh code?
TIA
Randy
I wrote an access program earlier this year at my previous position,
and I used some connection info that refreshed my current ODBC links on
my computer, allowing me to switch from my Test dB to my Production dB
without having to rewrite the code. I appropriately named my ODBC
connections, and then passed Test or Prod to the code, and it switched
them around, prompting me for username and password when I changed form
one environment to the other.
I have been googling this all day, and I can't find any code that
resembles what I used.
Anyone have short, easy ODBC connect/refresh code?
TIA
Randy