Error Importing Specifications

[x0200196]

Hello,

I'm trying to import two specifications from one access db (test.db) to another (production.db). I'm getting two error messages when I attempt this: "The search key was not found in any record" and "Not all of the import specifications could be imported due to name conflicts. Conflicts existed in 10 of the specifications."

So here's what I've attempted so far:

1. I made sure there were no spaces in my field names in either specification. I read that this is what caused the search key error.
2. I deleted every specification from the test.db with exception to the two I need. The error still says there are conflicts in 10 specifications. How? There are only 2 that are left to import.
3. I renamed the specifications in the test.db - still doesn't work.

Any idea as to what is going on? I'm not trying to import anything other than the import/export specs. I tried with the tables that I use them on but everything imports except the specs.

The steps I'm taking are: External Data --> Access --> I select my test.db --> Options --> I check Import/Export Specs, deselect Relationships (Have tried with relationships checked as well) --> and finally I click OK.

[blue4512]

Did you try to compact & repair the databases or analyze performance? it may help

[x0200196]

Did you try to compact & repair the databases or analyze performance? it may help

I done the analyze performance but it didn't help. I'm not sure if I know how to compact & repair the db. Could you explain what that entails, please?

[blue4512]

2007 Access

Windows Icon
- Manage
- Compact & repair