I have created a macro in Microsoft Access that will not run in VisualCron. I get an error of "Unhandled Exception You entered an expression that has an invalid reference to the property Visible"

My macro has the following Actions

SetWarnings
Open Query
Open Query
Transfer Text
Transfer Text
OpenQuery
OpenQuery
TransferSpreadsheet

Any ideas on what I need to do to get it to run successfully? I can run it just fine from Access (Microsoft Access > Macros > Select Macro > Run).

The problem could be that you have a quit command somewhere in your macro.

---

Hi Henrik

I converted my macro to VBA and there's no Quit command included in the logic. We are using version 4 of VisualCron by the way.

I suggest you try with latest version as there have been changes to this Task. Try on a new server first or test locally.

---

We are working on trying to get upgraded but budget issues and we have a bunch of servers. My solution was to create a .bat file with the logic below, then enter that bat file in the Command field within the task. Works great :)

ECHO OFF

F:
cd :F:\Access"

"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "F:\Access\dbCheckForErrors.mdb" /X macroFindErrors

EXIT

We are working on trying to get upgraded but budget issues and we have a bunch of servers. So what I did was use a Desktop Macro which gets the job done in some form of automation.

The only problem is that it requires the foreground mode.

---