Access - Publish report to word and save

I have an access 97 report that must be closed as the table it is based on must be deleted. However, I would like an input box to appear asking if they want to save the report.

Therefore, I would like to (In code) publish it to word and save it.

Any thoughts?

Why delete the table? Why not just delete all records in the table, thus maintaining the relationship between it and the report?

You're absolutly right. Wish i'd thought of that. However, project is done with the exception of this and it would cause way too much grief to go back and change.

I am going to cave and do what you said. Is there a command you know of to dump a tables contents? The only way I know howw to do this is deleting every row of a recordset but there has to be a more efficient way of doing that......

Any ideas??

Thanks a bunch

VB Code:

Dim SQL As String
SQL = "DELETE FROM tablename" 
dbobject.Execute SQL