Changing Database Type and Location at Runtime

[aabruce]

help!...


I have numerous Crystal reports... well several hundred! and we are chaning the database type and location... they all currently look at a paradox table, and we want to change them so they use an Access database instead...
We want to do this at runtime, but we appear to have hit a stumbling block.. We can change the database driver and set the location easily enough to point to the .mdb file but how do you select the table within the .mdb file where the data is?

 

[Tckazz]

Are talking about the datbase location setting within the report it's self or your VB application?

 

[aabruce]

its the location & databse type in the report.. Want to change all of the reports using VB (excel)