?
Solved

Access Errors:  Names Conflicts, Search key errors ,and no current record Redux

Posted on 2007-04-01
13
Medium Priority
?
556 Views
Last Modified: 2008-01-09
Hello all!

I am getting a myriad of errors when I try to edit forms in an Access 2002 .mdb that I "inherited."  Yes, I have tried to rebuild without success, and receive the same errors during the process.

I found an earlier posting:
 (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20990889.html)

that exactly describe my problems, but was resolved by the poster in a somewhat inelegant manner.  Just wondering whether two years later,  there is a cleaner solution to rebuilding a corrupt database that has gone horribly awry.  

Thanks,
Deb
0
Comment
Question by:DMV
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 4
13 Comments
 
LVL 75
ID: 18834339
In the VBA Editor ... Tools>>References .... and be sure none are **Missing

mx
0
 
LVL 75
ID: 18834346
If any are Missing, then 'browse' to the correct file ...

mx
0
 

Author Comment

by:DMV
ID: 18834453
I wish it were so simple... no references are missing....
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 75
ID: 18834461
Me too :-)

Ok ... does it Compile?

How about Decompile ....

I would say a **DeCompile** is on order ... and also check for any **Missing References via the VBA Editor>>Tools>>References ....

Follow this procedure:

1) Compact and Repair
2) Execute the Decompile >> you database will reopen
3) Close the mdb
4) Open the mdb ... and then do a Compile (from the VBA Editor >> Menu >>Debug>>Compile<YourProjectName>)
5) Close the mdb
6) Compact and Repair one more time.


Here are sample 'links'.  Adjust your paths and file names accordingly:

Run this from Start>>Run, enter the following command line:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile C:\Access2003Clients\GoldstandtSma\App\SmaApp2K3.mdb


"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile C:\Access2003Clients\GoldstandtPdm\App\PdmAppl2K3.mdb

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile C:\Access2003Clients\GoldstandtSma\App\SmaAppl2K3.mdb

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile C:\Access2003Clients\HMC\App\AimAppl2K3.mdb

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Program Files\Microsoft Office\Office\ADIvba11LIB.mda"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

mx
0
 
LVL 75
ID: 18834463
Sorry ... Ignore

"I would say a **DeCompile** is on order ... and also check for any **Missing References via the VBA Editor>>Tools>>References ...."

I cut and pasted from a txt file ... but ... do try the Decompile procedure ...

mx
0
 
LVL 75
ID: 18834467
DMV ... not a lot of information to go on here ...

Any chance you can upload to:

http://www.ee-stuff.com/login.php 

Removing any sensitive data of course?

mx
0
 

Author Comment

by:DMV
ID: 18834482
Thanks mx...

First of all, I have compacted the db, decompiled and recompiled (many times) to no avail.  

Second of all,  due to the proprietary nature of the db, I am unable to upload the database.  

Lastly, I hoped that an expert who has had experience with a corrupt database could give me pointers regarding reconstructing the application. As I am getting the aforementioned errors every time I try to edit  or export a form.

Best regards,
Deb
0
 
LVL 75
ID: 18834518
ok ... I'm just pulling out all the basics ... since I have no clue what you have or have not done. btw ... I have seen decompile fix many a corrupt mdb's.  Also ... missing refs and your symptoms ... are *normally* synonymous.

So next ... how about the ole import all objects into a new mdb?  

mx
0
 
LVL 75
ID: 18834533
Also Deb ... it would probably have helped to mention from the git go that you had recently done all of the things I've mentioned :-0)

What are some of the errors (#', etc) that you are getting?  Could you post some code where the errors are occurring?  Stuff like that.

Have you tried JetComp.exe ... although, sadly ... I have never seen that fix anything :-(

mx
0
 

Author Comment

by:DMV
ID: 18834682
In short, when I try to copy, export or import (into another database) certain forms, the error “Name conflicts with existing module, project or object library” appears.

And, whenever I try to save edits to said forms, the “save” is ignored and the prompt “Do you want to save want to save changes to design of form…” appears

Best,
Deb
0
 
LVL 58

Accepted Solution

by:
harfang earned 2000 total points
ID: 18834954
Hello Deb,

The question you point to is still the only final solution: import to a new database, in case of error, skip that object and continue. I had created an automated process for that (long time ago) because for some reason I managed to corrupt my VB code quite often.

First, make sure you create such a new database, one containing all tables and queries and all such forms and reports that you manage to import. Make sure the entire database is sound (compiles, can be imported in bulk to a new database, etc.)

For the broken objects, you can try several things.

1) see if the module is accessible (try to edit it)
If it is, export the module as text as backup. If not, the information is probably completely lost. In any case, try to remove the module (property Module: No) and save.

2) try to export as text.
The command is, from the immediate pane,

    SaveAsText acForm, "Your Form Name", "C:\Some\Path\And\Name.txt"

If that works, you can load it from file with the companion LoadFromFile command...

3) retrieve an earlier version from a backup
Sometimes, it's better to restart entirely, though. If it's an inherited application, try to find an old version where that form isn't yet corrupted.

Good luck!
(°v°)
0
 

Author Comment

by:DMV
ID: 18838079
Many thanks harlang with your pointer and LSM Consulting's routine (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21098089.html) all was recovered.

Also, thanks mx for your suggestions.

Best,
Deborah
0
 
LVL 75
ID: 18838313
lol
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question