Start simple in the IDE

Create a connection in the Server Explorer Access or SQL

Then pull in the tables

or

Create Connection to Database link to the data file,

Drop an adapter in then walk thru the SQL select statement for one or all tables which is shown above

Then right click in the IDE on the Adapter and create a data set from that, this will create a table based off of the Select statment so u can use 1 adapter for all 5 or 5 adapters for each Table

With all tables under 1 adapter you need to create command statement to update, insert or delete

If you use 1 table per adapter it will create them for u...

then use the adapter to fill the dataset or datagrid.. with the dataset u can do a databinding, same with the grid

Look at what the system created for u and try to grasp what it did to link it all together and what statements were created thwn edit them to see if you can adjust or change the way it display or updates..

Hope this will give u a starting point so u can start programming it manually to get a better idea of the entire process this is just the simple way to get started


or maybe I am entirely off but it was worth a try