How to create a dataset from access database at runtime

[Tom Loder]

I want to create a dataset at runtime from an access database (or another database) but at designtime I don't know the structure.

Ideally what I want to do is:

Dim ds as new DataSet = OpenAccessDB("MyAccessDB.mdb")

or

Dim ds as new DataSet = OpenDB("MyConnectString")

At the moment I only want to read in the database, but the ability to save the dataset back to another database would be cool!