Richard Korts
asked on
Batch running of Access
I have been having a lot of issues getting a windows scheduled process to work properly on a remote server.
The process worked for years. Effectively what it does is update one table in an Access database using a csv file; that table is linked to a Quick Books database table. Then it exports the contents of three Quick Books tables (all linked to MS Access) to csv files.
All this is initiated from a .bat file, with is command:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.E XE" "C:\C_LSS\DB\Linked_to_LSS .mdb" /x "LSS_MACR_Mo-1"
I realized today that in using GotoMyPC to access the remote computer, that I have been leaving Access OPEN in that computer overnight when the scheduled process runs.
When I look in the morning, Access is open & it is asking if I want to update a table, etc. Of course, I want all that to run transparently overnight.
Can I be causing issues by leaving Access "open" on the remote machine?
Thanks
The process worked for years. Effectively what it does is update one table in an Access database using a csv file; that table is linked to a Quick Books database table. Then it exports the contents of three Quick Books tables (all linked to MS Access) to csv files.
All this is initiated from a .bat file, with is command:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.E
I realized today that in using GotoMyPC to access the remote computer, that I have been leaving Access OPEN in that computer overnight when the scheduled process runs.
When I look in the morning, Access is open & it is asking if I want to update a table, etc. Of course, I want all that to run transparently overnight.
Can I be causing issues by leaving Access "open" on the remote machine?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your macro needs to explicitly close Access as the last step. It also needs to turn warnings off so you don't get any notification messages.
Leaving Access open this way could interfere with the ability of other users to open objects in design view. It could cause other update conflicts depending on what task Access is running.
Leaving Access open this way could interfere with the ability of other users to open objects in design view. It could cause other update conflicts depending on what task Access is running.
ASKER
How do I turn warnings off in the Marco (& queries it runs)?
How do I close Access at the end?
How do I close Access at the end?
Access 2010? In Macro design, click on the Show All Action ribbon option.
Now, you should see SetWarnings as an available option in the list of Actions.
SetWarnings No <-- turns warnings off
SetWarnings Yes <-- turns warning on
You'll also see an action named
QuitAccess
Make sure that's the last action in your macro as it will close the db and exit the Access application.
OM Gang
Now, you should see SetWarnings as an available option in the list of Actions.
SetWarnings No <-- turns warnings off
SetWarnings Yes <-- turns warning on
You'll also see an action named
QuitAccess
Make sure that's the last action in your macro as it will close the db and exit the Access application.
OM Gang
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I understand both of your inputs.
As I said in the posting, a slightly different version of this Macro has been running, unattended, every night, for about 6 years.
No problems.
So I don't know what to do.
As I said in the posting, a slightly different version of this Macro has been running, unattended, every night, for about 6 years.
No problems.
So I don't know what to do.
I don't think you answered my question from yesterday.
.....When you leave Access open are you leaving the same db open? E.g. are you accessing Linked_to_LSS.mdb during your GoToMyPC sessions and leaving it open?
OM Gang
.....When you leave Access open are you leaving the same db open? E.g. are you accessing Linked_to_LSS.mdb during your GoToMyPC sessions and leaving it open?
OM Gang
ASKER
I just discovered the original macro HAS SetWarnings No.
So I'm going with that on this one; see what happens tonight.
Thanks
So I'm going with that on this one; see what happens tonight.
Thanks
OM Gang