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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nothing that I'm aware of. I believe some of the recovery services can determine this, but I'm not really sure about that..
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.
Try repairing the database from access itself first. Then attempt the changes.
Tools > Database utilities > compact & repair database
Tools > Database utilities > compact & repair database
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Sorry to muck you about...
peter
PS thenelson, thanks fo rthe detailed post.
ASKER
Finally sorted after reverting to an old backup and getting the d/b cleaned up by EverythingAccess.
Many thanks to all involved.
peter
Many thanks to all involved.
peter
You're welcome. Glad to help and thank you very much for the points with the "A" grade!
Happy computing!
Nelson
Happy computing!
Nelson
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?
ASKER
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.
ASKER
Probably too much to expect!
peter