Open an Access Database Automatically

[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

 

[Mr. B]

Hi, Joe.

I have used the Windows Scheduler to a do this in the past. Give it a try.

 

[Joe Coulter]

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

 

[Mr. B]

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.