I have an Access 97 database, in .mde format. It contains a report that I want to open by use of a desktop shortcut that points to a macro in my .mde. I also have an autoexec macro that does other things at other times. Here's my problem:

When I click on the shortcut, instead of the macro to produce the report, it seems that the autoexec macro runs instead. I have the autoexec macro in place to do my actual hands-free data handling overnight, so I can't remove the autoexec.

Is there a way to somehow allow the user to bypass the autoexec macro and instead run the report macro? Here is the command line I have in my shortcut:

"C:\Program Files\Microsoft Office\Office\msaccess.exe" J:\APPS\SpecialReports\Source\SpecialDonations.mde /X openunlinkedreports

Thank you all so much - this forum is a lot more helpful than Microsoft Help or plowing through several books!

Rename the autoexec macro. That way it will only run when you want it to run. Your overnight process can run the db with a macro switch that executes the renamed autoexec macro. Another shortcut can be used to open directly to the report.

Thank you for your input...!! Sometimes the easiest ideas are the most difficult to get to.