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
Printable View
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
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