Avatar of pcalabria
pcalabria
Flag for United States of America asked on

Need accdb repair tool recommendation

I am having a variety of problems with my Access 365 db which include unexplained database in use errors when attempting to compact.

I'm wondering whether anyone has tried or would recommend
Stellar Access Repair, Stellar Phoenix Access Repair, or another other access repair tools.
Are they legit?
Microsoft Access

Avatar of undefined
Last Comment
pcalabria

8/22/2022 - Mon
ste5an

Run compact and repair with Access 2019, 2016 or 2013 and not the 365 version. Or use a new copy from your backup.

hmm, I don't know those tools, but do they more than Application.SaveToText and Application.LoadFromText?
John Tsioumpris

Start with decompile first and also check if a blank database can connect/link
pcalabria

ASKER
ste5an... I do not have other versions of Access installed.. what is the issue with 365 compact?

John.. if I move the db to a new folder.. I the operation works.. the first time.. from then on I get the in-use message
Rebooting solves the problem the first time I try to compact... then I have the same problem..

Your help has saved me hundreds of hours of internet surfing.
fblack61
John Tsioumpris

I suspect that you have structural issues...wirj with decompile and check what pops up...
pcalabria

ASKER
John.. what is "wirj "

ste5an

The 365 versions are not exactly the same built and in my experience, they are not as stable due to cloud issues.

E.g. my main development version is still 2013 (en-US).
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Gustav Brock

It sounds like you run the compact & repair having the file on a network share.
Copy it to a local folder and try again.

If that fails, create a new (local) database and then import all objects from the offending file.

If that also fails. you may consult Wayne at:

    https://www.everythingaccess.com/accessdatabaserepair_info.asp

for a trustworthy repair.
John Tsioumpris

My phone...:)..."work"
Jim Dettman (EE MVE)

Contact Wayne Philips at www.everythingaccess.com

While the automated tools can do the job sometimes, usually when a DB gets really messed up, it requires a manual effort.

Wayne is also the only one that can recover source code if the source is messed up or missing (.accde).

Jim.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Daniel Pineault

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pcalabria

ASKER
Yes, I have tried to decompile.  I have only used the o365 decompile as I do not have other versions of Access available.
Gustav... C&R of the FE is being done locally
Daniel.. I've heard of Exporting using SaveAsText/LoadFromText but have not tried it.  I will research how to do this.

Jim..As you know, I've had serious problems with this DB which Microsoft cannot solve for a long time.  I may try to contact Wayne to see if he can help.  I'll tell him you (and Daniel) referred me.

Daniel.. although I do not password protect my source...your website review, and comments about non-existing technical support and refund issues, will close the door to purchasing Stellar Phoenix Access Repair.  Thank you for the review.