G
Guest
My code creates a table for a report to use as its Record Source and I want
to delete the table when the report is closed. I have tried the following
code:
DoCmd.DeleteObject acTable, "My Table",
but I get an error stating that the database engine can not lock the table
because it is in use. When I try to remove the table as the report's Record
Source a message tells me that I can not set the Record Source after printing
has started, even if I'm not printing the report.
How can I delete this table?
to delete the table when the report is closed. I have tried the following
code:
DoCmd.DeleteObject acTable, "My Table",
but I get an error stating that the database engine can not lock the table
because it is in use. When I try to remove the table as the report's Record
Source a message tells me that I can not set the Record Source after printing
has started, even if I'm not printing the report.
How can I delete this table?