MSAccess 2010 batch process does not work anymore since mid july 2016

Question

Hi 

I had a perfectly working process. It was started bij a scheduled task which started process an msaccess db (query etc)

now it does not work anymore.  I've searched and tried for a month now and i'm getting pretty desperate in finding a solution.

Machine is a Windows Server 2008 R2, Access is 2010 version.

- starting the process in a cmd windows does not work alsoe

-  when debugging the programs the process does what is should do and finished properly, no errors are found or shown 

please help ..

Answer 1

Are there any error messages? Did you check the event logs to see if there are any events that may be related to your problem? What exactly happens when you try to start the process from the cmd window?

Matthias Kläy, Kläy Computing AG

Answer 2

For another client the password had expired for the user the scheduled task was run as.

---

-Tom. Microsoft Access MVP

Answer 3

If you are employing error handlers comment them all out and step through the process to see if every line of code is executing as it should.

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 4

Hi mnijskens,

According to your description, you could create a macro runs query then use command-line switches in Microsoft Access: /x macro, or create new Scheduled Task to make sure that this issue is able to be reproduced.

For more information, please refer to:

How to use command-line switches in Microsoft Access

Running Microsoft Access as a Scheduled Task

Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

Thanks for your understanding.