Access 2002 won't save changes

For the past two hours, my .mdb file does not save any changes I have made to its modules and form code. When I close down the database, it asks whether I want to save my changes and it goes through the motions when I say yes. However, when I open the database again, the changes have not been saved!

Incidentally, the decompile .bat does not do anything to this file either: it flashes open the C: prompt window and immediately closes it, apparently without doing anything...

Any ideas,

Many thanks.
PeborghAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'd bet a fair amount of dinkum that you've got a corrupt database, and most likely a corrupt VBA container. There's really not much in the way of fixes for this other than to move to a new database. In your case, I'd actually save the Modules as Text files (there's an option in the VBA EDitor to "export" them, which is the simplest way to do this), and then import them back into your new database.

You may also have a corrupt form/report. If so, then importing it into your new one could cause you to corrupt the new database. Generally you'll get an error when you try to import a corrupt object, and if you do then you'd import everything except that object and then either rebuild that object, or import it from a known good backup.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PeborghAuthor Commented:
Are there any tools to determine which bit of a database is corrupt?

Probably too much to expect!

peter
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Nothing that I'm aware of. I believe some of the recovery services can determine this, but I'm not really sure about that..
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jim P.Commented:
There is some software out there that can do it. For the cost I found it is easier to just import into a new blank database.
0
NerdsOfTechTechnology ScientistCommented:
Try repairing the database from access itself first. Then attempt the changes.

Tools > Database utilities > compact & repair database
0
thenelsonCommented:
Steps (approximately in order) to use to fix a corrupted Access database. (Test after each step.)

1) CREATE A BACKUP OF THE CORRUPT DATABASE. (Just in case)

2) Compact and repair

3) Use jetcomp.exe  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956

4) decompile: in run: msaccess "dbPathName.mdb" /decompile
   Compact/repair:  in run: msaccess "dbPathName.mdb" /compact
   compile: in VB editor: debug> compile
   Compact/repair
   http://www.granite.ab.ca/access/decompile.htm

5) Use a backup (you have a lot of those -- yes?)

6) If you can identify one or a few forms or reports causing problems, copy the problem form/report from a backup.  Or create a new form/report and copy all the objects in the old form/report to the new one. Copy the code from the old form/report using the undocumented
    Application.SaveAsText acForm, FormName, "C:\" & FormName & ".txt"
then paste that from Notepad into the new form/report.  If a module, copy the code using SaveAsText, create a new module, paste the code into the new module.

7) Create a new database, use File> Get external data> Import to get all objects of the damaged database and set up the options again.

8) Try a recovery tool:
   www.officerecovery.com/access/index.htm
   www.mvps.org/access/tables/tbl0018.htm

9) Hire a company to repair the database  http://www.pksolutions.com/services.htm

Additional information:
How to Troubleshoot/Repair Damaged Jet 3.0 and Prior Databases
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp

How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm
0
PeborghAuthor Commented:
In the meantime I found Evrything Access and their revival service. Any comments about this outfit?

Sorry to muck you about...

peter

PS thenelson, thanks fo rthe detailed post.
0
PeborghAuthor Commented:
Finally sorted after reverting to an old backup and getting the d/b cleaned up by EverythingAccess.

Many thanks to all involved.

peter

0
thenelsonCommented:
You're welcome.  Glad to help and thank you very much for the points with the "A" grade!

Happy computing!

Nelson
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
It would seem that my original post re: corruption would have also been included as well as Nelson's standard copy/paste reply. Was there some reason you failed to include my comment as well?
0
PeborghAuthor Commented:
as ever, compact and repair and decompile solved nothing but getting the d/b cleaned up by profesionals and reverting to some backups got me there.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.