Importing all objects into a new database

[cebrower]

I've created a new blank database and imported all objects from another database into the new one. Everything imported successfully except my import/export specifications. When I try to import them I get the error message "The search key was not found in any record". See the attached screen shot. Any ideas?

[ranman256]

You could try doing it manually,
show hidden tables,
in 1 of the SYS table are the specs.
copy /paste manually.

[Gicu]

Usually that message is associated with corruption, as ranman said you could check the system tables and copy them manually - MSysIMEXSpecs and MSysIMEXColumns are the two tables you might want to inspect.

Cheers,
Vlad

[cebrower]

Thanks Gicu. That worked like a charm.

[CJ_London]

be aware that just populating the IMEX tables (or copying as you have done) does not work - there is a property somewhere which activates them on first use (I.e. creation) - sorry don't know which one. Even though your import failed, it may have set this property - or it may not. So I would test it before you get too far down the road.

[cebrower]

After copying the IMEX files to the new database I ran the routine that imports some information that was exported from Quickbooks in CSV format and it ran with no errors. The records are deleted from tblCustListQB and then the table is re-populated by the import.

DoCmd.RunSQL "DELETE tblCustListQB.* FROM tblCustListQB;"
DoCmd.TransferText acImportDelim, "Customers", "tblCustListQB", "e:\Customers.csv", True