Automatic Data Updates in Access

[newnewbie]

Hi,
It might be a lot to ask from Access, but is there a way to have Access update/append/replace all the tables I need updated/replaced on its own (without the user opening the database, clicking buttons, etc.). In other words - is there a code/anything that can tell the database to wake up and run the queries/macros at 3 a.m. in the morning, for example.
Thank you!
Lena

[ADezii]

I've never done it, but with XP you can create a Scheduled Task to run at a specified Date/Time. The Scheduled Task would be Microsoft Access opening a specific Database with the /x Option (Run Macro). You could virtually do anything within the confines of the Macro. As previously stated, I've never done this, so you are basically on your own with this approach. Hope this helps.

[newnewbie]

I've never done it, but with XP you can create a Scheduled Task to run at a specified Date/Time. The Scheduled Task would be Microsoft Access opening a specific Database with the /x Option (Run Macro). You could virtually do anything within the confines of the Macro. As previously stated, I've never done this, so you are basically on your own with this approach. Hope this helps.

That's great news for a start!
Thank you!
Lena

[newnewbie]

Found this on the topic:

http://www.bluemoosetech.com/microsoft-access-vba.php?jid=8&title=Microsoft%20Access%20VBA%20Timer%20Event

[ADezii]

Found this on the topic:

http://www.bluemoosetech.com/microso...0Timer%20Event

You can forget the Timer() approach since Access and the associated Form containing the Timer() Event code must be open.

[newnewbie]

You can forget the Timer() approach since Access and the associated Form containing the Timer() Event code must be open.

Thank you. I'll explore the scheduled task...

[LBryant]

I've used a DOS batch file as a shortcut to open Access and run a specific Macro. It's what ADezii is referring to, I believe. In a notepad file type:

@echo off
"[full path to local Access application]" "[full path to database]"/x "[Name of Macro]"
cls

For example:

@echo off
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\Pclfile2\ccwork\Communication Business System\media calendar.mdb"/x "GraphicsRequest"
cls

Save the file as *.bat

[newnewbie]

I've used a DOS batch file as a shortcut to open Access and run a specific Macro. It's what ADezii is referring to, I believe. In a notepad file type:

@echo off
"[full path to local Access application]" "[full path to database]"/x "[Name of Macro]"
cls

For example:

@echo off
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\Pclfile2\ccwork\Communication Business System\media calendar.mdb"/x "GraphicsRequest"
cls

Save the file as *.bat

Thanks much!
I'll let you know how it worked!