Renaming a database after compacting it

[Peter Zeman]

I have a VB front end that uses an Access db.the path of the database is set in the code. After the db is compacted I would like to rename the new db to the original name so that the program can still find it.
Thanks in Advance.
Peter

[Clunietp]

Compact it to the users TEMP directory, delete the old database file and copy the new one to the old one's dir with the same name

Tom