Solved

HOW TO UPDATE MS ACCESS DATABASE WITH GPS DATA

Posted on 2014-11-23
6
434 Views
Last Modified: 2014-11-28
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.
0
Comment
Question by:Lance McGrew
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 58
ID: 40461162
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.
0
 

Author Comment

by:Lance McGrew
ID: 40461239
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,
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40461956
Lance,

 I'm not really up enough on the web/phone app world to really offer anything specific.  But just poking around on this for a few minutes, I did spot this:

http://www.geotagphotos.net/

 Which is another way you could approach this and one that might even work better; snap a photo of the offending light, GPS data is logged, and then both photo and GPS point is available for anything you might write in a Access Desktop app when you sync up your phone.

 Access web apps come close, but their still in their infancy.  If there was already a geo location App for Office (basically an add-in), I say you could come close, but you can't run disconnected and I think you still could do better with something else.

You project is a perfect example of what Access Web Apps need to be able to do however.  

and don't close this question yet.  Let's see if anyone else comes along with some better ideas or even better yet, a specific solution.

I would imagine this type of application must be needed by the real estate community.

Jim.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:Lance McGrew
ID: 40463659
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
0
 
LVL 58
ID: 40464237
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.
0
 

Author Closing Comment

by:Lance McGrew
ID: 40471158
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.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This Micro Tutorial demonstrates how to quickly find related content for YourTango's posts using MozBar Chrome extension.
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question