Clear contents of a table on exit (1 Viewer)

[andy_25]

Hi,

I have a database and due to data protection reasons I need to clear the contents of a table when the database is closed down, is there a way of doing this?

I have tried using me.undo in the form events etc to stop the data actually writting to the table however this causes problems so I would just like to clear on exit (of the database or the form in question).

Any ideas?

 

[PNGBill]

A form should clear when closed and a table can be cleared by a delete query deleting * in all fields.

Can you build into the Exit / Quit on your Menu to run the query and then quit.

 

[boblarson]

create a form that opens as hidden when your database is opened (you can do that using an autoexec macro).

Then in that form's UNLOAD event use

Dim strSQL As String

strSQL = "Delete * From YourTableNameHere"

CurrentDb.Execute strSQL, dbFailOnError

 

[andy_25]

create a form that opens as hidden when your database is opened (you can do that using an autoexec macro).

Then in that form's UNLOAD event use

Dim strSQL As String

strSQL = "Delete * From YourTableNameHere"

CurrentDb.Execute strSQL, dbFailOnError

Fantastic Bob, thanks a lot, I would have never been able to figure that out