HOW TO UPDATE MS ACCESS DATABASE WITH GPS DATA
Posted on 2014-11-23
Yard lights in our subdivision are the only means of illumination and residents are required by the covenants to keep working. As chairman of the architectural committee, one of my volunteer efforts includes driving around twice a year and record any address with a non-working light. With 435 potential addresses, this is a semi-annual burden.
We have a membership Excel Spreadsheet that needs to be converted to an Access Database. The geek side of me imagines driving through the neighborhood, finding a yard light out, and being able to use my iPhone GPS to provide the address I am at. I then have a screen to "tap" and the GPS data interacts with my Access Database on my laptop or cloud store the address followed by synchronize with my Access Database after returning home. Or just do everything via Google Docs provided we can create a mailing list.