Hi, How ca I compact data base before quit in the code? thanks
P Peter De Baets Aug 12, 2003 #2 If you're using Access 2000 or greater, then check Tools > Options, General tab, "Compact on Close". Otherwise, you can try these tools: You can also use the TSI SOON utility to close a database, compact it, and then open it again (it also copies NT file permissions to the new file): http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8 Another utility is Compact Current MDB From Code: http://briefcase.yahoo.com/lylefair Hope this helps,
If you're using Access 2000 or greater, then check Tools > Options, General tab, "Compact on Close". Otherwise, you can try these tools: You can also use the TSI SOON utility to close a database, compact it, and then open it again (it also copies NT file permissions to the new file): http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8 Another utility is Compact Current MDB From Code: http://briefcase.yahoo.com/lylefair Hope this helps,
