Macro done in command button on a form intending to print a report gives error message that database is locked. Macro was set up in ACCESS 2002 to 1)open report; then 2) printout. Are there any other steps?
I presume you mean that the report first of all is opened in Print
Preview, and then supposed to Printout. This is not really a good plan.
For one thing, what the Printout macro does is tries to print the
"active object", which you have no way of ensuring that this is your
report at the time. If all you want is the printed report, just use an
OpenReport action, with the View argument set to Print.
Having said this, I do not know whether this is related to your database
locked problem.
