My Access program has a line
DBEngine.CompactDatabase……
to compact a database.
The line worked fine in a machine with Access 2000 SP3 and WinXP Pro SP2, but crashed in a machine with Access 2000 SP3 and Windows XP Home SP2. Can anyone give me a clue why it happened this way?
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
DBEngine.CompactDatabase (Access 2K SP3)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » DBEngine.CompactDatabase (Access 2K SP3)
- This topic has 8 replies, 2 voices, and was last updated 20 years, 6 months ago.
AuthorTopicWSlesoch
AskWoody LoungerDecember 2, 2004 at 10:18 am #412995Viewing 1 reply threadAuthorReplies-
WSHansV
AskWoody Lounger -
WSHansV
AskWoody Lounger -
WSlesoch
AskWoody LoungerDecember 2, 2004 at 11:29 am #907780 -
WSHansV
AskWoody LoungerDecember 2, 2004 at 11:45 am #907789I doubt that Windows XP Home itself is the culprit (although I cannot be sure about this)
Has the latest service pack for Jet 4.0 been installed on the Windows XP Home PC? See How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine for details.
-
WSlesoch
AskWoody LoungerDecember 3, 2004 at 12:02 am #908205After scratching my head and wasting your precious time in answering my posts, I managed to solve the problem. It wasn’t Windows XP Home nor the version of my MSJet, it was the corrupted back-end data! I actually and simply copied the original data from a WinXP Pro machine to my WinXP Home machine and did some data entry. Then the DBEngine.CompactDatabase surfaced. When I browsed through separately the back-end database with Access, some records had “Invalid bookmark” problem. After replacing the corrupted database with the original one, DBEngine.CompactDatabase works as expected.
Now is my time to find out why the database got corrupted….
Thanks for your reponse, Hans.
-
WSlesoch
AskWoody LoungerDecember 3, 2004 at 12:02 am #908206After scratching my head and wasting your precious time in answering my posts, I managed to solve the problem. It wasn’t Windows XP Home nor the version of my MSJet, it was the corrupted back-end data! I actually and simply copied the original data from a WinXP Pro machine to my WinXP Home machine and did some data entry. Then the DBEngine.CompactDatabase surfaced. When I browsed through separately the back-end database with Access, some records had “Invalid bookmark” problem. After replacing the corrupted database with the original one, DBEngine.CompactDatabase works as expected.
Now is my time to find out why the database got corrupted….
Thanks for your reponse, Hans.
-
-
WSHansV
AskWoody LoungerDecember 2, 2004 at 11:45 am #907790I doubt that Windows XP Home itself is the culprit (although I cannot be sure about this)
Has the latest service pack for Jet 4.0 been installed on the Windows XP Home PC? See How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine for details.
-
-
WSlesoch
AskWoody LoungerDecember 2, 2004 at 11:29 am #907781
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Microsoft-Backed Builder.ai Set for Bankruptcy After Cash Seized
by
Alex5723
32 minutes ago -
Location, location, location
by
Susan Bradley
1 hour, 1 minute ago -
Cannot get a task to run a restore point
by
CWBillow
1 hour, 58 minutes ago -
What is wrong with simple approach? (Awaiting moderation)
by
WSSpoke36
6 hours, 9 minutes ago -
Frustrating search behavior with Outlook
by
MrJimPhelps
9 hours, 30 minutes ago -
June 2025 Office non-Security Updates
by
PKCano
12 hours, 43 minutes ago -
Secure Boot Update Fails after KB5058405 Installed
by
SteveIT
5 hours, 24 minutes ago -
Firefox Red Panda Fun Stuff
by
Lars220
12 hours, 40 minutes ago -
How start headers and page numbers on page 3?
by
Davidhs
23 hours, 4 minutes ago -
Attack on LexisNexis Risk Solutions exposes data on 300k +
by
Nibbled To Death By Ducks
1 hour, 45 minutes ago -
Windows 11 Insider Preview build 26200.5622 released to DEV
by
joep517
1 day, 7 hours ago -
Windows 11 Insider Preview build 26120.4230 (24H2) released to BETA
by
joep517
1 day, 7 hours ago -
MS Excel 2019 Now Prompts to Back Up With OneDrive
by
lmacri
21 hours, 27 minutes ago -
Firefox 139
by
Charlie
14 hours, 3 minutes ago -
Who knows what?
by
Will Fastie
4 hours, 24 minutes ago -
My top ten underappreciated features in Office
by
Peter Deegan
1 day, 8 hours ago -
WAU Manager — It’s your computer, you are in charge!
by
Deanna McElveen
1 day, 2 hours ago -
Misbehaving devices
by
Susan Bradley
4 hours, 12 minutes ago -
.NET 8.0 Desktop Runtime (v8.0.16) – Windows x86 Installer
by
WSmeyerbos
2 days, 14 hours ago -
Neowin poll : What do you plan to do on Windows 10 EOS
by
Alex5723
11 hours, 47 minutes ago -
May 31, 2025—KB5062170 (OS Builds 22621.5415 and 22631.5415 Out-of-band
by
Alex5723
2 days, 12 hours ago -
Discover the Best AI Tools for Everything
by
Alex5723
1 day, 12 hours ago -
Edge Seems To Be Gaining Weight
by
bbearren
2 days, 3 hours ago -
Rufus is available from the MSFT Store
by
PL1
2 days, 11 hours ago -
Microsoft : Ending USB-C® Port Confusion
by
Alex5723
3 days, 14 hours ago -
KB5061768 update for Intel vPro processor
by
drmark
1 day, 13 hours ago -
Outlook 365 classic has exhausted all shared resources
by
drmark
1 day, 12 hours ago -
My Simple Word 2010 Macro Is Not Working
by
mbennett555
3 days, 9 hours ago -
Office gets current release
by
Susan Bradley
3 days, 12 hours ago -
FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers
by
Alex5723
5 days, 2 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.