I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardAccess VBA Programming Topic   Print This     

Corrupt mdb file

Corrupt mdb file in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: Corrupt   Corrupt mdb   Corrupt mdb file  
sjmoore
 (Inactive)
Carson City, NV USA

I have an mdb file that appears to have some corruption.  I have run the "compact and repair database" utility several times.  This utility runs without reporting any problems.  However, there are about 5 forms of about 60 in the mdb file that, when modified cause MSAccess to crash.  I have also tried to start with a blank mdb file and cutting and pasting every form, table, query, report, from the old file to the new file and the same problem occurrs with the same forms.

I am desperately hoping for some advice from somebody to hopefully help me save all the code that I have done and not have to build it again to get rid of the problems (it would really be a pain).

 Thanks in advance.

 Posted 11 years ago (Thread Starter)
Comment Quote
About sjmoore -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12428, 5 replies
Thread Started 1/20/2008 2:03:56 AM
View Counter=5538
Last Reply Posted 10/27/2011 10:53:27 PM)
Location=Carson City, NV USA 
Joined=11 years ago   MB Posts=2  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
I've run across this a few times and it has geneerally ended up being easiest to rebuild the forms.  the good news is that you may be able to cut and paste from code and objects from the old form.  Providing you can even open them in design mode.  Give it a try with one of the bad actors and see if the form still give s the problem.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 11 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #12706 (Level 1.1)  Reply to 12428
Thread Started 4/25/2008 11:42:25 AM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
ParaDelphi
-- USA
Samantha: Did you ever find an additional tool? I have a similar problem where Access' Compact and Repair doesn't report any errors.

----
Paul "The Coder" Santoro

 Posted 11 years ago
Comment Quote
About ParaDelphi -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About ParaDelphi

Paul has been developing in paradox and delphi since the mid 90s.


Post ID #12703 (Level 1.2)  Reply to 12428
Reply Posted 4/24/2008 5:15:47 PM
Location=-- USA 
Joined=12 years ago   MB Posts=23   KB Comments=2  
sjmoore
 (Inactive)
Carson City, NV USA

Well, as a fluke I ended up finding out what the problem was.  Turns out I had installed Access 2003, SP3.  The SP3 got installed as part of the automatic update feature I have set up with MS.  However, I had another computer that had this feature turned off and still had Access 2003 SP2.  For some reason I ended up modifying the same code on this computer without any problems.  So I started investigating why.

Turns out, Access 2003 SP3 has a nasty bug where the runtime code corrupts its memory and makes the code crash.  The Compact and Repair does not detect any problems because there aren't any with the code.  SP2 does not have this bug.  So I downgraded all my workstations to SP2 and the problem was solved.  I also downgraded my customers and have had no problems since.

 Hope this helps.

 Posted 11 years ago (Thread Starter)
Comment Quote
About sjmoore -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12708 (Level 1.3)  Reply to 12428
Reply Posted 4/26/2008 8:30:35 AM
Location=Carson City, NV USA 
Joined=11 years ago   MB Posts=2  
Anonymous Post

Hi,

  Here are some Access database recovery tools that may help you to repair your mdb file. Below is a list of them:

http://www.datanumen.com/aar/compare.htm

Most of them provide a free demo so you can try first.

Alan

---
Alan
 Posted 8 years ago
Comment Quote

Post ID #14705 (Level 2) and Parent is 12428
Reply Posted 10/27/2011 10:51:37 PM
Most Recent Post
Anonymous Post

Hi,

  Here are some Access database recovery tools that may help you to repair your mdb file. Below is a list of them:

http://www.datanumen.com/aar/compare.htm

Most of them provide a free demo so you can try first.

Alan

---
Alan
 Posted 8 years ago
Comment Quote

Post ID #14706 (Level 3) and Parent is 12428
Reply Posted 10/27/2011 10:51:37 PM

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1103A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12428 Counter
5538
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech