How to Delete a database *.mdb with VB?? (1 Viewer)

[lukea51]

I have a database that has a list of database locations stored in a table with in the the database. What the function of the database is; to compact all the databases that are in the table. The code compacts the database copies it and date stamps it in the title.

My question is how to delete the original .mdb file after the database has been copied and compacted?

 

[pbaldy]

Look at the Kill statement in VBA help.

 

[namliam]

Why "date stamp" it? Why not compact it and have Access do the copying back and stuff?

 

[lukea51]

Thanks for your help