Linking Database to Dataset

[pjholliday]

Is there anyway of having a dataset that is linked to my access database in such a way that when the database changes the dataset automatically updates itself?

[exhaulted]

The idea of ADO.net is to work on databases without an active connection so i wouldn't have thought so. You could get the program to create the connection every X Minutes / Hours and update the dataset accordingly. Kev