Clearing a database...

[mjohnson629]

Is there a way to program a yes/no message box to clear all the fields in a database? If so I'd really appreciate some pointers... Thanks...

 

[DataMiner]

Do you mean you want to delete all the data from all the tables? Or what?

You want the user to be able to do this? (Are you sure????)

 

[Robert88]

Hi mjohnson629,

Check the attached mdb, is this the sort of thing you were after? Check frmClearTable and click the button within to clear the tblDetails contained within.

Like Data Miner indicated are you sure you want your users to do this?

I hope it helps

Robert88

 

[mjohnson629]

Well to be honest I think it is a bad idea. But the sponsor for our project doesn't want to keep the data after the semester. The database is for a "Biggest Loser" competition among the staff and faculty of my university. Our sponsor doesn't want to save any "sensitive" data.