cannot reference mda add-in file after conversion

[rdiamond]

I am working on converting an old Access 97 application so that it can work with Access 2013. I am able to convert the database file; the problem is that the original database had a customized add-in file (.mda). This add-in file includes functions and variables referenced in the application (I opened the .mda file in a text editor). After converting the database, I cannot create a reference to the add-in file - it says 'Can't add a reference to the specified file.'
I have tried this using Access 2003, 2007 and 2013. I tried de-compiling, compact/repair and then compiling the application in Access 97 before converting; I also tried creating a new database in Access 2003 and then importing all the tables, queries, forms, and modules. Any assistance would be greatly appreciated!

 

[HiTechCoach]

I am working on converting an old Access 97 application so that it can work with Access 2013. I am able to convert the database file; the problem is that the original database had a customized add-in file (.mda). This add-in file includes functions and variables referenced in the application (I opened the .mda file in a text editor). After converting the database, I cannot create a reference to the add-in file - it says 'Can't add a reference to the specified file.'
I have tried this using Access 2003, 2007 and 2013. I tried de-compiling, compact/repair and then compiling the application in Access 97 before converting; I also tried creating a new database in Access 2003 and then importing all the tables, queries, forms, and modules. Any assistance would be greatly appreciated!

The customized add-in file (.mda) will have to upgraded also. You can use a .mda that is a JET4 (2000 or 2003/2003) format. Best is to convert to the new ACE format.

HiTechCoach's TIP:
Make a copy of the .mda and rename it to .mdb. Can you open the database? If is is not compiled (.mde) then you can upgrade it to a newer format.

 

[HiTechCoach]

cross posted here: http://www.accessforums.net/modules/cant-add-reference-specified-file-56884.html

 

[rdiamond]

I received a helpful reply on accessforums.net, and then encountered a different error.

I'm not able to post links, see cross-posting message above for updated thread.