Delete Table in Report

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
 
J

Jeff Boyce

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
 
S

Sarah

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.
 
J

Jeff Boyce

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
Converting GPS coordinates to decimal in Report 0
Delete Table 5
Can't create a report from my query in Access 1

Top