Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Setup / Configuration / March 2004

Tip: Looking for answers? Try searching our database.

Compact and Repair runs forever !?!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David - 31 Mar 2004 16:51 GMT
When I run a compact and repair on my Access 2000 database, I get an hourglass and it runs forever. Task manager shows no activity in MSACCESS.EX

Does anyone know what this means

I can open and use the database and nothing seems amiss with it. But not being able to compact and repair it concerns me.
Eric Butts [MSFT] - 31 Mar 2004 20:40 GMT
Hi,

It could be a sign of corruption probably in your database especially if it
happens with only this file.  Use JETCOMP.exe to see if you can compact it
(repair corruption), see: ACC2000: Jet Compact Utility Available in
Download Center
http://support.microsoft.com/default.aspx?scid=kb;en-us;273956

Also to make sure it's not your machine down and install the latest service
pack the Microsoft JET Database Engine
http://support.microsoft.com/?id=239114

Here's another article to assist with corruption in Microsoft Access
databases
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

I hope this helps!  If you have additional questions on this topic, please
respond back to this posting.

Regards,

Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026?  If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch.  Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Compact and Repair runs forever !?!
| thread-index: AcQXN/8T6osC5cS+SlCOkn2npXOrpg==
[quoted text clipped - 20 lines]
|
| When I run a compact and repair on my Access 2000 database, I get an hourglass and it runs forever. Task manager shows no activity in
MSACCESS.EXE

Does anyone know what this means?

I can open and use the database and nothing seems amiss with it. But not
being able to compact and repair it concerns me.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.