I require VC++ source code (class, functions etc) to view and print (with print preview) MSAccess 2000 reports from my VC++ program. The code may use Automation with opening a new window (MSAccess) to display the reports. Assume MSAccess will also be installed on the computer.
I've already got some code on the net to achieve this but this doesn't work with Access 2000 format. All the code avalable on net works with only Access 97 format.
The function should accept the Access database filename to generate the reports. It shoudl give a dropdown list of tables in the database for which the report is to be generated.
Hint: I know this can be done using automation where the VC++ program invokes MSAccess directly and MSAccess in turn generates and displays/prints the reports. This will be done transparent to the user with the report viewed in a separate window.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Source code to be well commented.