Compact and Repair...1 or 3 times ?

[PACALA_BA]

Access 2003 sp3, todays expierience....
MyData.mdb
import all objects from MyData_backup.mdb
(Missing tool Import ALL OBJECTS in ONE CLICK.....)
close MyData.mdb
Compact and Repair
Open MyData.mdb
CRASH-1 (First)
Report crash to microsoft, and restore and Repair
Open MyData.mdb...second times
CRASH-2 (Second)
Report crash to microsoft, and restore and Repair
Open MyData.mdb...third times
O.K. (NONE-CRASH)



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-a7b8-e5c81973b06a&dg=microsoft.public.access

 

[Arvin Meyer [MVP]]

I like to do a compact 3 times to clean out every vestige of junk.