Workaround for Action:Quit after upgrade from '97 to 2000

[Don Hicks]

Hello,

I've got a problem and am not sure which newsgroup to post to. Please feel
free to re-post this in a more appropriate newsgroup, if necessary (but
please let me know if it's being moved).

I designed an Access '97 database containing some macros which are called by
various outside programs.

Each of the macros in question ends with Action: Quit .

I was asked to upgrade the software to Access 2000, which I did.

We have converted the database to an Access 2000 database, but now the
called macros no longer function properly because, as I understand it,
Access 2000 no longer supports the "Quit" action in a macro.

So, my first question is, "is there a simple substitution for the Quit
action in a macro used in Access 2000?"

I have tried to convert the macros in question to modules; however, this
poses a new problem for me in that the outside programs are looking to call
the old macro names.

So, my second question is, "what is the best way to call a module from an
outside program (such as the Windows Task Scheduler)?"

Sincerely,
Don Hicks
Portland, OR

 

[Steve Schapel]

Don,

I am not aware of any difference in functioning of the Quit macro action
between Access 97 and later versions, so it is a mystery why your macros
"no longer function properly". It may have nothing at all to do with
the Quit action. It is certainly not true that "Access 2000 no longer
supports the Quit action in a macro". However, you could try using the
RunCommand/Exit action instead.