Selct from Multiple Access mdb's
-
I'm relatively new to VB programming and I have written an Access 2000 application and am currently copying the Access mdb's for each different database. My users have as many as 3 or 4 databases each. This is a nightmare if I have to make a code, form, or data structure change. What would you suggest as an alternative? I am trying to create a VB application that would allow them to select what Access database they want to work with and process from there. Sort of like selecting the database to open from a Common Dialog. Any suggestions for a quick and efficient method would be appreciated.
-
I'm relatively new to VB programming and I have written an Access 2000 application and am currently copying the Access mdb's for each different database. My users have as many as 3 or 4 databases each. This is a nightmare if I have to make a code, form, or data structure change. What would you suggest as an alternative? I am trying to create a VB application that would allow them to select what Access database they want to work with and process from there. Sort of like selecting the database to open from a Common Dialog. Any suggestions for a quick and efficient method would be appreciated.
Well, if you're using ADO.NET, then all you have to do is change the connection string in your OleDBConnection object. Just let the user select whichever one they want, modify your connection string, and assumining that your databases are all the same that should be all you need to do. Hope that helps! Daniel E. Blanchard
-
Well, if you're using ADO.NET, then all you have to do is change the connection string in your OleDBConnection object. Just let the user select whichever one they want, modify your connection string, and assumining that your databases are all the same that should be all you need to do. Hope that helps! Daniel E. Blanchard
Each user is on a standalone laptop or desktop. All databases are identical in structure. No .NET. I change the ODBC DSN when they run reports that I have created in Crystal Reports. Other than that they open the .mdb they want to update and then run the reports. No networking or servers are involved.:-D