ODBC Auto Password Possible?

[Matt]

Hi All,

Here is my situation:
I have a database that needs to be compacted and repaired nightly. I
have the process working and ready to go, but I have hit a snag with
an ODBC password.

I have a query that runs at every :02 and :32 of the hour. The first
time this runs (The first :02 or :32 on the hour after I have opened
it) I must put the ODBC password in. Every time after that the
password is not needed (I guess I stay logged in).

I want to be able to compact and repair my database at night, which
will force me to close and open the database. I still want this query
to run at every :02 and :32 after it is opened back up, but currently
it will not be able to because it will be waiting for me to put in the
password for the first time.

Is there a way to send the ODBC source the password through code? Any
other Ideas?

As always,
Thanks in advance for all of your help!

 

[Guest]

Matt - have you tried to use the Send Keys action in a macro to enter your
password? I run a nightly database refresh that hits several ODBC sources and
have used the Send Keys action without a problem. Granted a Compact and
Repair process is different but it might be worth a try.

 

[dbahooker]

god damn kids

if you just use Access Data Projects; you would have a full fledged
SCHEDULER

I mean.. compact and repair.. in the year 2007-- ARE YOU FRIGGIN
KIDDING ME?

MDB is dead and it has been for a decade

 

[Matt]

Matt - have you tried to use the Send Keys action in a macro to enter your
password? I run a nightly database refresh that hits several ODBC sources and
have used the Send Keys action without a problem. Granted a Compact and
Repair process is different but it might be worth a try.










- Show quoted text -

No I havent ... I will try that. Thanks!!