Has anyone ever uploaded SIMS to the internet? Im asking because im the squadron ITO and were trying to upload it so that flight coms and flight sgts can access it while at home. If you have can you assist me in the process.
SIMS is a distributed Access database. This means separate files for the data and the user interface. This works fine on one computer, OK on a local network and horribly over the internet. I would also suggest SIMS contains some information that should not be available to cadet staff.
An alternative would be to load selected data from the CAPWATCH download to a MySQL or Postgress database and use Access to connect to that.
Im not worried about the SIMS data, I have that taken care of. Its mostly uploading it to the Internet.
Unless you have a VPN that is passing Windows services, you can't share it across machines, however you could zip up the files
and share them on a service such as Google Docs or Dropbox.
Make sure you have a process to identify who has the "gold" copy, because if you have more than one person making changes
at a time, they will overwrite the work.
Do not post that info on an open web server.