Crystal Reports 11 and VB

[keenanbr]

When I setup a report in Crystal with a certain DB User and then run the report through VB I get the message 'table or view does not exist'. If I take the SQL query and run it against the database it runs fine. The only way I can get it to run through VB is to got into Crystal and change the DB location.

Thanks

 

[vidru]

If you're using VB6, take a look at my FAQ on changing data sources at runtime: faq768-5374.

Have a look at the addendum toward the end of the FAQ for the best way to do it with CR XI.

-dave

 

[keenanbr]

Thanks, that was a great help.

Regards,

Brian