VisualDeveloper
Programmer
I have a main report which contains around 5 subreports. For each of the reports inlcuding the main report I set the data source by using the ADO ConnectionString and Data Link Properties dialog box. The problem is, when I move my VB application to another location including the database, the reports no longer functional as they try to look in the older place. How can I change that ConnectionString at runtime, so basically change:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\Desktop\Autohouse Solution\Data\dbAutohouse.mdb;Persist Security Info=False"
To:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data\dbAutohouse.mdb;Persist Security Info=False"
Please help - Im using VB6 with Crystal Reports 8.
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\Desktop\Autohouse Solution\Data\dbAutohouse.mdb;Persist Security Info=False"
To:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data\dbAutohouse.mdb;Persist Security Info=False"
Please help - Im using VB6 with Crystal Reports 8.