How to delete & rename files?

[P.S.W.]

Hi everybody,

I am compacting a database file and need to delete the old file and rename the new one. Can anyone help me with the VB code/syntax used to rename & delete files? Your help is appreciated.

[ExcalibursZone]

Take a look at the MSDN documentation and look for:
FileSystemObject. This should help you with your file needs.

-Excalibur

[Chris_SE]

to delete a file use this:
where filepath = the files path

kill filepath

to rename a file do this:
where oldpath = the original name and directory
and newpath = new name and directory

Name oldpath as newpath