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?