• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

Scheduling Access

Hi,

I have a scheduled task to open an Access DB which then runs a macro.

If i do this manually, it is fine, if i schedule it over night it does not run. Is there an issue with the fact im logging off?

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
  • 6
  • 5
  • 2
2 Solutions
 
GreenclockCommented:
You need to schedule the job using a User that has Administration rights. Using the system account does not work

Take a look at the following Microsoft Document

http://support.microsoft.com/kb/230575

Hope this helps

Greenclock
0
 
Jeffrey CoachmanCommented:
FWIW, if you use this, log on/log off is irrelevant:
http://www.fmsinc.com/microsoftaccess/Scheduler.html

0
 
Seamus2626Author Commented:
Thanks guys, ive went through the steps from the Microsoft site but i cant seem to get it going.

Ive typed the below into Notepad and saved it. It wont open though, and the error message appears very quickly and goes away

C:\Program Files\Microsoft Office\officeMsaccess.exe C:\Copy of Triple Link_2011-03-15.mdb /x Macro1
 /x Macro1

Is there an error in the above path possibly?

Thanks
Seamus

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Seamus2626Author Commented:
I tried putting it in the CMD editor and get the following error message

Z:\>c:\program files\microsoft office\office Msaccess.exe\c:northwind.mdb/x macr
o1
'c:\program' is not recognized as an internal or external command,
operable program or batch file.

Thanks
Seamus
0
 
GreenclockCommented:

Seamus

Try putting Quotes round items in the command line.  The problem is that there are spaces in folder/file names and these are causing it to be treated as 2 or more command line items.

C:\Program Files\Microsoft Office\officeMsaccess.exe "C:\Copy of Triple Link_2011-03-15.mdb" /x Macro1

Greenclock
0
 
GreenclockCommented:

For the command prompt test........

"c:\program files\microsoft office\office Msaccess.exe" "c:{full path}\northwind.mdb" /x macro1

Greenclock
0
 
Seamus2626Author Commented:
Thanks Greenclock.

I saved a file called MyTes.bat and entered

cmd.exe/c
"c:\northwind.mdb" /x macro1

That works fine if i double click it, but wont run when im logged off, it says in the scheduled taks "running"

Its using my user name where its says "Run as"

Do you think its an administration issue?

Thanks
Seamus


0
 
GreenclockCommented:
Seamus


Which Operating System and version of MS Access are you using?

Greenclock
0
 
Seamus2626Author Commented:
Its 2003 Access and Microsoft Windows XP Professional

Thanks
Seamus
0
 
GreenclockCommented:
OK

- Does the macro have an entry to exit MS Accees?  
This may explain why it keeps on running...

- Is the ID you setup the job with and Administrator?
 Reason: To run a task while not logged on you need "Run As a Batch" rights.  The administrator access will allow this when the job is created.

You can grant this right using the "Local Policy Settings" Tool.

Type the following at the command line:
     ntrights.exe -u {user or Groupname} +r SeBatchLogonRight

If you get an error then the Windows Resource kit is is not install
http://go.microsoft.com/fwlink/?LinkId=4544

Greenclock
0
 
Jeffrey CoachmanCommented:
To run a scheduled task you must have Admin rights.

In other words "you must be a member of the Administrators group" in order to run a scheduled task.
So you will have to set this up in the "Run As" option when setting up your scheduled task.

See Here:
http://technet.microsoft.com/en-us/library/cc786711%28WS.10%29.aspx

And here:
http://technet.microsoft.com/en-us/library/cc780931%28WS.10%29.aspx

See the attached screenshot as well, it shows where this is set up when you create a a Windows Scheduled task.

Does this all help?

JeffCoachman
untitled.JPG
0
 
GreenclockCommented:

In this case getting the MS Access job running successfully I would recommend using an ID with Administrator righs as mentioned by Jeff. But only in the first instance to get this working, but this is not something that is required permentally.  A lot of damage can be cause if the script goes wrong.

Administrators have the Batch Right by default, but it is possible to run a task, while not logged on, with a non-Administrators ID provided the "Log as a Batch" right has been.


Greenclock
0
 
Seamus2626Author Commented:
Thanks guys, need to get myself set up with Admin rights

Cheers,
Seamus
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 6
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now