Mar 17, 2010 #1 Pack10 Programmer Feb 3, 2010 495 US Does anyone know why it takes so long for an access 2007 database to close?
Mar 17, 2010 #2 MajP Technical User Aug 27, 2005 9,382 US It is not a systemic problem. I have never seen it. It may be specific to your installation, computer, or network. Upvote 0 Downvote
It is not a systemic problem. I have never seen it. It may be specific to your installation, computer, or network.
Mar 18, 2010 Thread starter #3 Pack10 Programmer Feb 3, 2010 495 US We only have SP1 installed, SP2 to be installed soon, that might clear that up....agree?? Upvote 0 Downvote
Mar 18, 2010 #4 jsteph Technical User Oct 24, 2002 2,562 US Some db's (Not sure if 2007 has this) can be set to "Compact on Close", which would take some time. --Jim Upvote 0 Downvote
Some db's (Not sure if 2007 has this) can be set to "Compact on Close", which would take some time. --Jim
Mar 18, 2010 #5 MajP Technical User Aug 27, 2005 9,382 US 2007 was very problematic without the SPs. They may help. Here is some info: http://allenbrowne.com/Access2007.html Upvote 0 Downvote
2007 was very problematic without the SPs. They may help. Here is some info: http://allenbrowne.com/Access2007.html