Sharing Data via the Internet

[stingrae]

Me and my business partner were wondering if it was possible to do the following:

We have a PC based application written in Visual Basic .Net that uses ADO.Net to access (read/write) an .mdb database file.

We would actually like several people to use this database, but not via a LAN. For example, everyday or week, whenever, have them logon, access the .mdb file and have it download some information. Then at irregular intervals, allow them to upload some data to the mdb file.

I did try this but with no success so far. All that happened was that the operating system copied the whole .mdb down to my C drive as a local copy.

Please advise on the above, and also if you have any other ideas.

Thanks.

[Edneeis]

Look into remoting. A dataset is serializable so you could remote one across the web, but beware a NAT router if there are any callbacks involved.

[average_coder]

Is it possible to bind a grid to a remoted DataSet? I have been trying to do it for about a week now. When I set the DataSource of the grid to the remoted DataSet, it seems to bind to a snapshot of the DataSet. When a value in the DataSet is changed, the grid does not reflect the new data. If you know how to get remoted DataSets working, please let me know...

Thanks!