Delete Table in Report

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Does anyone know how to delete a table that is being used by a report after
the user previews the report, then closes the report? I tried using the
onclose event to delete the table, but the error states it's still in use.

Thanks for any suggestions.

Sarah
 
Sarah

I'm not understanding your situation well enough to offer meaningful
suggestions...

Why would you need to delete a table? What "business need" are you
attempting to satisfy by doing that?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
It's a temproray table which is created before the report is previewed and I
want to delete it after the user is done previewing the report. I don't want
it to stay in the database.
 
Sarah

I'm sorry if I didn't express my question well enough.

Why do you have a temporary table at all?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top