Open an Access Database Automatically

  • Thread starter Thread starter Joe Coulter
  • Start date Start date
J

Joe Coulter

Hi

I have created a mdb database which I have converted to a mde, The database
closes down each night after a period on inactivity, now I need the database
to open automatically each morning prior to 07:30 and run a query, how do I
do this?, I have searched for a solution without any luck.

I would appreciate some help.

Thanks in anticipation

Joe
 
Thanks Mr. B

I created a vbs file that opens the Db, then populates the Username and
Password entries, The Db then runs the Macro to upload data, then closes. I
then used the Task Scheduler to Run the vbs file, It worked a treat, thanks
for the inspiration.

If you do however know of a better way, I would be interested.

Regards

Joe
 
Joe,

Glad you got it to work.

Using the scheduler, you can actually provide the UserName and Password in
the same command line statement that opens the database, thus eliminating the
need for the VBS.
 
Back
Top