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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Table which is the RecordSource in a Report 6
Delete table in a Report 1
report's onCLOSE executes ONOPEN (AND onclose)!?!?!? 4
Deleting a tempory table upon closing a report 13
Deleting table after being used in a report in the recordsource 10
Reports that sift records from different tables 0
Can't create a report from my query in Access 1
Drawing a grid on a Report 2

Back
Top