I am after some advice and examples of code or relevant links so I can do some research before I start writing my new application in VB 2005.
Firstly this application will need to be both single user and multiple user. However when i say multiple user i mean users need to be able to use the application and share the data across the internet.
I need to know what is the best way to achieve this and ideally with free tools.
My initial idea was that on installation the user is given 2 choices:
Single User - which uses a local database like an mdb on the local machine or even a local copy of MySQL if thats not to difficult to distribute.
Multiple Users - which uses a MySQL database out on the internet or local network and asks the user for database details to connect to or where to create the tables.
How difficult is this to do?
If the user chooses to store the data in a mysql database out on the www then is it possible to synchronize the database back to a local pc version in the event the user is not always connected to the internet. I understand that this could possibly cause errors if multiple users have edited the same records at different times so if there is no connection to the internet i would want the application to work in "read only" mode.
Is all this possible? I'm not sure even if vb.net 2005 can talk to mysql on the www yet?
Advice please? Points awarded for the most userful information!