I am looking for advice regarding using several access databases from a web page. The history is that I have put together about a half dozen databases that make our life very nice here at our small office. Additionally, I built a small web page for intranet usage locally as well. As it turns out, we have a couple of other small offices that would greatly benefit from using our databases. The problem I have is that the databases are created for sorting a variety of parameters and turning up a record. This record has a couple of fields that indicate where the file is located. The files are large autocad type files. The database that has all the links itself is a little over 10 mb in size at the moment. Additionally, it runs a couple of queries (delete temp table data, copy paste records, trim function etc.) upon startup to make the search quick and convenient.
Long story short the other offices are tied to this office but the bandwidth between them is pretty horrible. That will be very unlikely to change not to mention long in coming should the change be approved. Locally, all is well. Once you leave the intranet and geographic area of my office, opening the database is terrible as you have to transmit the 10mb or so to your computer just to run the database.
What could I do to convert the database to be used from afar so that it would not take an eternity to open or search. Currently, the database has over 20000 records and grows a couple each day or two. I have been looking at data access pages but so far nothing has stuck out as an obvious answer.
Thanks in advance.
Long story short the other offices are tied to this office but the bandwidth between them is pretty horrible. That will be very unlikely to change not to mention long in coming should the change be approved. Locally, all is well. Once you leave the intranet and geographic area of my office, opening the database is terrible as you have to transmit the 10mb or so to your computer just to run the database.
What could I do to convert the database to be used from afar so that it would not take an eternity to open or search. Currently, the database has over 20000 records and grows a couple each day or two. I have been looking at data access pages but so far nothing has stuck out as an obvious answer.
Thanks in advance.