I have been reworking macros for the past 5 days and nothing is working the
way it is supposed to.
Access 2003
The macros I created work fine if the database is open and I just run them.
I am trying to run the macros from the command prompt.
I have created a shortcut,
Start in: c:\Program Files\Microsoft Office\Office11
Target:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"s:\Directory\Analysis.mdb" /x "PrintReport"
No matter what I do, compile the database, compact and repair etc.
in the middle of the macro a window opens "This action will reset the
current code in break mode"
Clicking no the macro processes run but then the database freezes and I have
to end program with task manager.
Any suggestions would be more than welcome, thank you.