Is it possible to delete a table on exiting a form or on exiting Access 2000

Thanks for any help

--
Mike

Mike,

Not only possible, very easy too! Use the form's Close event to run this
line of code:

DoCmd.DeleteObject acTable, "YourTableNameHere"

Just make sure you compact your database regularly, creating and
deleting tables results in high database bloat. If this is a single user
database, using the Compact on Close option (Tools > Options, General
tab) will do the job just fine.

HTH,
Nikos

On Sun, 9 Oct 2005 23:49:02 -0700, "Mike"
<(E-Mail Removed)> wrote:

>Is it possible to delete a table on exiting a form or on exiting Access 2000
>
>Thanks for any help

I just have to agree with Nikos that a) it's easy, follow his
instructions and b) that it probably *should not be necessary*.

Are you creating a Table just for the purpose of displaying or
printing data? If so, don't; you can base a Form or a Report on a
Query without the extra step of creating a separate table.

John W. Vinson[MVP]