Link to home
Start Free TrialLog in
Avatar of oneDayAtaTime
oneDayAtaTimeFlag for United States of America

asked on

Account-Related Issue opening Access 2007 from Scheduled Task

I am migrating an existing Scheduled Task from a server in one domain to a server in another domain. The servers are both running Windows XP Standard Edition, SP2. I have Active Directory Service accounts, created specifically for the task, in each domain. I also have Microsoft Access 2007 on both servers. The task runs a macro in an Access dbs via a .bat file. The .bat file is essentially as follows:

E:
CD\Program Files\Microsoft Office\Office12
Msaccess.exe "E:\program files\myDBS.mde" /WRKGRP "E:\program files\myDBS.mdw"/x macroName
exit

I can't get the Scheduled Task to run in the new domain with the new service account. If I use MY personal Active Directory account, it runs fine. If I use my Service Account, nothing. I've narrowed it down to my service account not being able to open Microsoft Access. I did this by streamlining the .bat file as follows:

E:
CD\Program Files\Microsoft Office\Office12
Msaccess.exe
exit

My personal account will open Access fine. The service account will not. I also verified that the Service Account WILL run Scheduled Tasks. I wrote a simple .bat file that just changes a file extension, and my Service Account WILL run that Scheduled Task. It just hangs when it tries to open Access.

Another odd thing I've noticed is that on the existing installation, when the Scheduled Task runs, it does NOT visually open Microsoft Access. It seems to run the macro in the background. But on the new server (new domain), when I get the Service to run under my personal account, it physically opens Access, runs the macro, then closes Access. I'm not sure if that's relevant or not so am including it.

My Service Account is an Administrator on the server. It seems to have the same permissions on the server as my personal account. Any ideas? I'm hoping there's a security feature in Access 2007 that I'm missing? Thanks for any help/ideas!
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oneDayAtaTime

ASKER

I was able to resolve the issue, and included the details in my comments.