I have to say I'm French, so please forgive my english.

I need to convert a VB application connecting to Access DB to be now
connected to an Oracle DB.  I have 6 Crystal 7 reports to change.  I use the
Crystal Report control (OCX) to open reports.

I'm not so much familiar with Crystal Report, but one of my friends said  I
have to convert the database driver in my *.rpt files.  I did it (in
Crystal Report, DataBase Menu, Convert Database Driver) and I chosen my ODBC
connection to the Oracle Database in the drop down list ( I use MSDASQL).
  The conversion seams to be made, but it doesn't work well. W hen in Access
we had information coming from 4 tables (A, B, C and D), now information
only comes from table A.  I don't know what's wrong or what to do to resolve
the problem...

Another question : why the option "Database - Show SQL Query" wasn't
available when I connected to Access DB, and now that I connect to Oracle DB
it's
 available ?

Will I have to create a new report because I connect to an Oracle DB instead
of an Access DB ?   I forgot to say that the new Oracle DB is made from
the Access DB, so all tables and columns names are the same.  I think there
is no reason to produce a new report that will be identical....it's just
that I'm not familiar with CR, and help files are so...well I prefer not to
talk about help files !

Please help me, I don't know what to do !