How to access DataSet from a remote machine

[rizwan6feb]

There are two versions of my application. First runs on a local server and the second version runs on a client machine.

The application on the local server performs that following tasks

1. Pulls data from an online Mysql database and stores it in a DataSet
2. Makes changes in the DataSet and updates it back in the online database

I need to access the data (i.e the DataSet) on the client machine, so that the client can also Add, Edit and Delete records. Is there any way i can achieve this?

 

[Tom]

One option, you could output the dataset to an xml file that both can access.

 

[rizwan6feb]

Ok, then how will the records be synchronized between different machines

 

[cjard]

Er. Why don't you just have the clients connect to MySQL?