I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB
.NET and one of the things I would like to do is link in to the compiled Access ADE so that I can use the reports that have already been created. I have somewhere in the region of 200 reports already created in MS Access and I really don't want to have to create new ones.
I have successfully linked to the Access ADP, but this displays the access application which I don't want to do as it exposes the code.
I want the the access ADE to work as a kind of black-box, where I can just call it to generate the report.
Can this be done?
Any ideas as to how I do it?
Alternatively, is there a tool out there that will convert my Access reports into Crystal reports?