Kindly advise me how can i change database at runtime.
I use VB 6.0/Access, Crystal 8.5 (Crystl32.Ocx) and Creating reports through DSN. I have 4 or More Databases in which Tables are same and structure is same. only data is different. When I run VB Appl select one Databse. I want reports to retrive the data from the selected Database. Everythime user change the Databse. Reports should retrive the Data from the selected Databse.
So, How it can be done. as of now i'm working on Single Database only and bind all the reports at design time. Since Access Databse supports only 2 GB. So i have to store the data year wise in separate databse.