Avatar of Lance McGrew
Lance McGrew
Flag for United States of America asked on

HOW TO UPDATE MS ACCESS DATABASE WITH GPS DATA

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.
Microsoft AccessiOSGoogle Workspace

Avatar of undefined
Last Comment
Lance McGrew

8/22/2022 - Mon
Jim Dettman (EE MVE)

Access 2013 would get you part way there, but not all the way (GPS part).  You'd need an app for Office to integrate GPS data.

The other restriction would be that you need to be on-line, so if you had an air card your good.  If not, you'd need one.

Another way  handle this is to use one of the GPS software suites out there, one in which it lets your record your own "trail" (waypoints), and then export them.

Jim.
Lance McGrew

ASKER
Jim, I certainly like the idea of using waypoint data.    In the past have used several outdoor cycling apps to harvest ride data.  Has been a couple of years since the days of playing with GPS iPhone Apps so if you can, please recommend something you know would play well with MS Access 2013?

Regards,
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Lance McGrew

ASKER
A couple other uses for such:

- Folks that are out on those Sunday afternoon house shopping
- Neighborhood committees doing judging for best yard awards, best Christmas display etc.
- Farmers could record crop location issues
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Jim Dettman (EE MVE)

Yes, I would think something like this already exists in one form or another, but let's see if anyone else jumps in.  If not, then we'll see if we can get a little more detail into this.

Jim.
Lance McGrew

ASKER
Jim, I am now receiving the lack of activity email notice.   Will close and award the points to you.  Certainly would like to explore this further some day.