Hi All,
I've been asked to update an old word doc system with a database and I haven't ever worked with disconnected db's before so I thought I would post this topic here and see what you all feel would be the best method to achieve the desired result.
Basically, The system used to work by officers having laptops which had huge word documents on them that contained info the officers need in the field. Once a week the officer comes into the office and connects the laptop to the network and runs a batch file to update the document with a new version (basically deletes the old one and imports the new one. This works fine for the officer but it is a hassle for operations on the backend as users would like to use the data for other projects but are limited by the format (doc instead of mdb) So... I have been asked to convert this system to a database.
Now my initial thought is to store the data in SQL Server on our network and then the officers laptops will have a local version of the db with local tables. They will be able to view data locally and then when they connect to the network they can refresh the data in their local tables (Note* There is NO NEED for data to change by the end users and update back to the server - data processes will only run From the Server to the laptop local dbs.)
What would be the best way to set this system up? I have set up a connection string to the server but I guess my main problem is how do I go about refreshing the data in the required tables...?
Thanks in Advance,
Kev
I've been asked to update an old word doc system with a database and I haven't ever worked with disconnected db's before so I thought I would post this topic here and see what you all feel would be the best method to achieve the desired result.
Basically, The system used to work by officers having laptops which had huge word documents on them that contained info the officers need in the field. Once a week the officer comes into the office and connects the laptop to the network and runs a batch file to update the document with a new version (basically deletes the old one and imports the new one. This works fine for the officer but it is a hassle for operations on the backend as users would like to use the data for other projects but are limited by the format (doc instead of mdb) So... I have been asked to convert this system to a database.
Now my initial thought is to store the data in SQL Server on our network and then the officers laptops will have a local version of the db with local tables. They will be able to view data locally and then when they connect to the network they can refresh the data in their local tables (Note* There is NO NEED for data to change by the end users and update back to the server - data processes will only run From the Server to the laptop local dbs.)
What would be the best way to set this system up? I have set up a connection string to the server but I guess my main problem is how do I go about refreshing the data in the required tables...?
Thanks in Advance,
Kev
Last edited:
