Executing Access macro

[Gnorro]

Hi
i execute an access macro from a batch file. I use this command:



"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" file.mdb /x Import /nostartup

The macro is executed correctly but i see always that access window starts, even if i use /nostartup command. How is possible?

the second problem is about what happens when the macro gives an error.
I would like that in every case msaccess process is killed. This macro is scheduled in windows task, so every morning when I open task manager, I see a lot of msaccess.exe processes.

So i would like to know how to force the killing of access process when the work is ok but also when it's not ok. Now I use the "Quit" command inside macro. I see also a lot of other commands but i don't know which is better to use

last thing: is it possible to wite the result of the macro executed by access in a log file? If not how can i know if the macro is ok or not?

thanks

[dcrake]

Alot depends on what the macro is doing. You may be better in converting the macro to vba and running the code. You have more error control.

[Gnorro]

i cant do that.
i need to use the macro that way
any other idea?