How to Synchronize offline form...

[ByNary010101]

Hi all, I was wondering if you could help me out with some ideas on a project I am going to start working on.

This application will be used in local hospitals and clinics to monitor hardware and software installations and the main functionality I am trying to get is as follows:
--Technician will connect to the network and dowload all information pertinent to his/her installations (ie. department the install will happen in and what is being installed)

--The technician will then be allowed to disconnect from the network and go to his/her assignments and be able to update the application with notes and other installation information

--After all installs are complete the technician will then reconnect to the network and upload all information that was collected throughout the day.

I will be developing this with VB6 SP6, SQL Server (as the master database), and Access (used on individual computers). My thoughts were to basically do it as I said above, technician will connect to the network download all of the information to a local Access database, when the technician is done doing installations he/she can simply update the local database, after all installations are done, the tech will plug back in to the network, click a "Syncronize" button and all information from the Access database will update the master SQL server database.

This sounds too easy, is there something I might be over looking here?? Has anyone done something similar that could give me some pointers?? Thanks a bunch

 

[johnwm]

Welcome to Tek-Tips. To get the best from these forums please read faq222-2244.

This project sounds straightforward enough. You might consider MSDE for your local DB as you've then only got one lot of DB coding considerations. You can always come back to us if you meet any specific code holdups.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[ByNary010101]

Thanks for the reply...how easy is it to package the MSDE with the VB project using the standard Package and Deployment Wizard?? This is kind of jumping the gun a little bit, but the P&D Wizard frankly sucks, what other deployment packages are out there that I might be able to learn to use in about 1 week?? Thanks again.

 

[johnwm]

Do a search on the forum for INNO or Wise. There has been some discussion recently about both. You will also find guidelines for basic research in faq222-2244

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts