Solved

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

Posted on 2007-04-01
13
554 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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 500 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

730 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