Delete table on exit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks for any help
 
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
 
Is it possible to delete a table on exiting a form or on exiting Access 2000

Thanks for any help
Click to expand...

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]
 
Back
Top