Automating A Process

[Ray S.]

I have an MS Access database (using 2003 SP3). Every day I have to make an
ODBC connection to a company server that stores all financial general ledger
transactions. There are only certain times during the day that we are allowed
to download data. Normally, I come in early in the morning and run code that
downloads all the data I need for the day, but my boss prefers that I have it
run at the end of the day automatically (like overnight). It takes some time
to run. I'd like to somehow schedule the running of the code late at night.
One thing also is that when I run the code now, since I'm present, I have no
problem providing my userid and password, but I'm not sure how I'd do that in
the scheduling. I'd really appreciate any helpful ideas?

 

[Klatuu]

You can use the Windows Task scheduler to open your database and run the
code. You can use command line options to pass your user id and password
and you can also identify a specific macro to run when the database opens.

For details look in Access Help for Startup command-line options

 

[Ray S.]

I looked at that and it won't work. I can give it my Novell userid and
password, but that only allows a login to the computer...that goes through a
series of interactive things as well...I could leave my computer on to
minimize those processes, then all that would be required would be my Novell
id and password to unlock the workstation...then, I'd have to have the
specific Access database open on a network drive...and, I'd have to have the
code run automatically, like an autoexec batch file...during the running of
that code a dialog pops up to establish the ODBC connection...it is here that
I need to provide an userid and password for access to the server...The
wizard for scheduling just doesn't work for all that...I tried...unless I'm
missing something.

 

[Klatuu]

I have a process that runs after hours. We installed Access on the server
and it runs from there; however, given it is a Novell server (people are
still using it?), I don't know if it will run an MS app or not.

 

[Ray S.]

OK, let's forget about having to sign in to my workstation through the Novell
Services dialog. Assuming I have already signed in, my Access database has to
log in to a server to get access to the data...that is, when the code runs a
dialog pops up asking for my user name and password. How do I get past that?