Need to delete database

[labanTek]

Hi good day I have an app that is done in access2002 and I installed it using a windows installer.When users quit the app using a command button I want the database to be automatically deleted from the users computer. I tried the following code to run a batch file but the database does not close off completely fast enough to be deleted by the batch file. Any suggestions? If I put the code after the quit command the code does not run. Please help.

'runs the batch file to delete database

Call Shell(Environ$("COMSPEC") & " /c c:\DeleteData.bat", vbNormalFocus)

 

[PHV]

Why not using a .VBS playing with WScript.Sleep instead of a .BAT ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[labanTek]

That sounds interesting, can you point me to a website or thread with some help with this?

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/60f96092-6021-42f3-9a27-6848f4c38f64.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886