Hi Alvin
There after is the code I'm using in my programm
'Compact database
DBEngine.CompactDatabase "access to the database to be pack (c:\mydb.mdb)","Access to the new database (c:\mydb.new)", dbLangGeneral, dbversion25
Kill c:\mydb.mdb
Name c:\mydb.new As c:\mydb.mdb
Hope this help
Jean Michel