Single VB.Net app using multiple Access mdb files in windows app
Posted on 2010-08-26
I am rewriting my current vb6 application using vb.net (vs 2008) with access database. Current app allows only one .mdb at a time. The new requirement is to allow users to open more than one account (each an .mdb files with multiple tables). Copy, move information from one to the other. It would be like Microsoft Word document where you can open multiple documents and view side by side and be able to drag and drop info from one to the other. I have no idea where to begin and how to use multiple connection strings (?), how to keep track of which database is user working with and so on. I will greatly appreciate any guidance.