
VB App, Crystal Reports, and ODBC and Native db drivers
I'm looking for recommendations.
I have a VB app that was designed to work with an Access database using the
Jet Engine.
We currently have 150+ reports designed in Crystal that we send with our
product. They are designed using the native Access driver included with
Crystal.
We are now in the progress of extending the app so that our clients can have
a choice between
MS Access (for single users), or and ODBC database. The database structures
will be similiar.
Is it possible to re-create the 150+ reports so that we can can connect to
either the Native driver or the ODBC driver?
I have been playing with Crystal 7.0's ActiveX and their Automation Server,
but I haven't found a clean method.
Any advice or ideas where I can research this information would be helpful.
Thank you. Shawn