Here are the details about my local development computer environment: - Windows 7 Professional 64-bit Operating System - Microsoft Office Access 2007 (12.0.6735.5000) SP3 MSO (12.0.6743.5000)
At work, I received these 3 Microsoft Access files that are used to generate reports for one of our applications:
I've been given the responsibility of trying to understand the code and database schema associated with said files.
The main file is the ReportEngine.ADP file.
I opened up the ReportEngine.ADP in Microsoft Office Access 2007 which in turn opened up Microsoft Visual Basic Editor.
In Microsoft Visual Basic Editor, I navigate and click on Debug -- > Compile ReportEngine , but it gives me the following error:
"Compile error: Can't find project or library"
Then, I navigate and click on Run -- > Reset Next, I navigate and click on Tools -- > References , and I get the following Window Screen:
Microsoft Access dialog windows missing reference ade file
I clicked on the "Browse..." shown in the dialog window screen above, and I specify the file RptEngCore.ade which was one of the other Microsoft Access files that I mentioned in the list at the top of this stackoverflow posting. Unfortunately, it still mentioned that the said file was missing by showing the same dialog window screen shown above again.
I thought the error could be resolved by registering the RptEngCore.ade from Dos command prompt.
I ran Dos command prompt in Administrator mode, and ran the 64-bit version of regsvr32 registration command: C:>%systemroot%\SysWoW64\regsvr32 RptEngCore.ade
However, it gave me the following message:
Windows Registration file compatibility issue
I thought that I might need to run the 32-bit version of regsvr32 registration command:
C:>%systemroot%\System32\regsvr32 RptEngCore.ade
I still got the aforementioned registration message shown above
Could someone please tell me how I can get Microsoft Access to acknowledge that the RptEngCore.ade exists?
@wayne-g-dunn and @danielg : Thank you for your posts.
However, when I upgraded to Microsoft Access 2010, the reference RptEngCore.ade dependency was successfully seen by Microsoft Access 2010.
I spoke to the original developers, and they said that they develop/maintain/support the application using Microsoft Access 2010.
