I am trying to build an application that allows the user to use a .mdb located locally on users computer and update an .mdb file on the internet. The only reason for the local .mdb is because use of the form needs to be able to react off-line as well as on-line. Specifically, the user will always update the local database and only update database over the internet when a)connected of course & b) when user specifies (ie. on_click). Synchronization of these databases is not the problem in a sense, I have been researching for the past few days and I am not able to narrow down a search on this subject, hence the question. I am successfully updating the local database with OleDb Connections. I understand that SQL server is my best bet, but my company and I are not able to use this technology yet and need for this application is growing. Now to the questions.
1). Am I able to do this? Can I connect to and successfully update,delete,insert data into an Access database over the internet? I have been here http://www.carlprothman.net/Default.aspx?tabid=93#MSRemoteAccess
(best by far) and a few other places to locate the connection strings but to no avail. Also, I have visited most the links provided within EE forums for past subjects on this matter.
2). With ADO & OleDb controls, do I connect to the .mdb via Internet with ConnectionString?
(ie. Provider=MS Remote;" & _
;" & _
Or rather something similar? Is there something more involved I am missing or is this the only mandatory item to connect? If I can connect and do one simple select or update, I will be off and running.
3). Is there another approach I am overlooking?
4). Is this a stable procedure? (Accessing .mdb's over Web)
This application is done in VB.NET 2005 (VS 2005 non-beta) and is quite stable as far as local database moves. Thanks for your time and I appreciate ANY input into my situation.
Thanks in advance,