This how i am planing to synchronize my desktop application with my website.
1. I have created a text file.
2. every time a user inserts or updates a record - the sql statement is added to the text file.
3. On closing the application or when the user desires that text file is uploaded to the ftp on the website domain
The when the websites is opened , it check if there any new files.
It runs the statements in text file, executing one at a time to update the website database.
The the website user can view data and also run reports.
I have a feeling there are likely to be better ways i can do this, help please