Name Conflict Error

[scotthutchings]

I have a complex database that has several hundred forms. The database runs great. When I try, however, to import all of my forms into a new database, I receive 2 different error messages that both arise twice (once on each of 2 forms).

The first error message states, "Name conflicts with existing module, project or object library." Once I select OK, I get another error "No current record." Again, this occurs on 2 separate forms, one is named "PM - Enter PO Quote" and the other is "PM - No WantDate Form". I have checked all of my tables, queries, forms, reports, macros and modules to ensure that these names are not used twice.

The second error I receive states, "The search key was not found in any record." Once I hit enter, the following error message appears: "Microsoft Access database engine could not find the object 'PM - Fax'. Make sure the object exists and that you spell its name and the path correctly. If 'PM - Fax' is not a local object, check your network connections or contact the server administrator." In this case, the name of my form is "PM - Fax". I have confirmed that the form exists but I don't know where else to look to resolve these items.

Any ideas?

Thanks!
Scott

 

[RuralGuy]

Start by doing a /decompile: http://www.granite.ab.ca/access/decompile.htm
Then a Compact and Repair and then a compile and Compact and Repair again. See if you still have the innsues when you try and import everything into a new db.

 

[scotthutchings]

When I run the code:

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" /decompile "C:\IMS\080811\Database4.accdb"

I get an error that states:
"'C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE"' is not recognized as operable program or batch file.

I am running Windows 7.

 

[RuralGuy]

You need to locate where the MSACCESS.EXE for ac2010 is located on your system. Mine is in the \Program Files (x86) sub directory.

 

[spikepl]

I think you can get away with

"C:\IMS\080811\Database4.accdb /decompile"