Access with MS SQL
Hi, I have a database in SQL and I need clients to connect to it but they don't have Internet access. I mean, they'll have Internet access from time to time, but not all the time.
They are going to be entering products into the system and they need to see if the product meets certain conditions specified on the database.
How can I create a version of it on the client's computer?
Would I need access or something like that?
You can create a replicate of the remote database on user's local machines.
Personally, I would use XML files. Basically, when the user connects to the Internet, a connection to the remote server is established, and sync in an XML format is saved locally on user's machines.
If a user updated records on whilst offline, these changes will be flagged and once connected to the Internet, you can apply those changes.
It is not going to be an easy ride, but I think you are better off using XML files.