Import Error - Microsoft Access has encountered a problem... 1

[chadrj]

I have a database originally created with Access 97 now in Access 2002. While in 97 I created some import specifications to import some text files. Now the format of the files have changed so I need to change the import specs. The problem is that when I try to import a text file through conventional means(file -> Get External Data -> Import) I get the dreaded "Microsoft Access has encountered a problem and needs to close." This error occurs after I select the text file to import. If I revert back to the 97 version there is not a problem, but the 2002 version gives me this error every time.

Is this a problem with my pc, or is it an Access problem?

I have seen documentation on this error for other reasons, but none on the text file import. I realize Microsoft's error description is descriptive enough that I should obviously know what is wrong, so I apologize for my laziness.

Thank you for any help you can provide.

Never try to teach a pig to think. It doesn't work and it annoys the pig.
-Anonymous

 

[Savil]

Import Specs in Access 97 are held in a hidden table called MSysIMEXSpecs you may be able to copy the info straight into your new DB or at least compare it with new the one.

Hope this helps

 

[chadrj]

Thanks for the helpful information. I changed the Import Spec in the 97 DB and copied the MSysIMEXSpecs file over to my 2002 DB (after renaming the 2002 spec file). It also needed to copy the MSysIMEXColumns table because it inculdes the column names of for the specifications. Now all is well.

Thanks again,
Chad

Never try to teach a pig to think. It doesn't work and it annoys the pig.
-Anonymous