I use VB2008 and database access and Crystal report.
my problem : when ever I change location the database. I will always change location in my report from crystal report. It's very difficults and waste the time because I have many report.
Please help me how to set up location only 1 place and impact to many report.
My VB Code :
Dim dbname1 As String = "D:\AF_Software\DB\DBAF1.mdb"
Public Strcon As String = "Provider=microsoft.jet.oledb.4.0;data source=" & dbname1 & ";jet OLEDB:Database Password=999"
Please help me to make code in crystal report , if i want change drive to drive Z / or somthing else.
now, i am go to the report and click change location.