I need some help with the code to compact a database
I am using VB6 and an access 2000 database i was wondering if anybody knew the code to compact it, all i have been able to find is how to compact it when using an access 95 database.
In particularly i am having trouble with this code
'Close the database and make a backup copy gcnFmmc.Close FileCopy "Fmmc.mdb", "Fmmc.mdk" 'Repair and compact to a temporary database lblMessage.Caption = "Compacting..." DBEngine.CompactDatabase "Fmmc.mdb", "Temp.mdb" 'This is the line of code i get an error on 'Erase the temporary database Kill "Fmmc.mdb" Name "Temp.mdb" As "Fmmc.mdb"
thanks,
rightwest