External Access for Internal DB
Can someone confirm or point me in the right direction for what i would need to do to allow staff external\remote access to our school reporting system.
Currently the system is available in school via intranet. The system is a simple set of html\asp front end webpages that are linked to a backend ms access database.
It worked well in parts this time around (first time in use actually)the one problem was staff completing reports at home, to do so they saved pages to a usb stick took them home and then brought them back in completed and then uploaded those pages. Simple enough but it caused problems.
So for next term allowing them external access would be make life easier.
I did not write the web pages or do the initial setup and have little asp coding experience hence my question..
So what do i need to do to set this up for next time around? Is it a simple case of creating an external address doing a nat on the firewall to point to the internal server and the iis\asp pages take care of themselves or do i need to recode any pages?
thanks for any pointers..