update map on webpage from access db

I have an extremely simple db one table TblCountry and TblNames.

The name table has names of people who emigrated from Dover along with the country code (autoid) of TblCountry.

I have a wordpress site.
At present I have a decent png of a map of the world and just edited the totals against each country manually.  but its too labour intensive.

Is it possible and how could I update the map from the DB.

so if USA went from 9 people to 10 it would be updated from the db.

Heres the query data:
Country      Number of People
Within UK      12
USA      6
Australia      6
Spain       5
Germany      2
Virgin Islands      1
Singapore      1
Portugal      1
Norway      1
New Zealand      1
Greece      1
Gibraltar      1

SELECT TblCountry.Country, Count(TblNames.CountryID) AS [Number of People]
FROM TblCountry LEFT JOIN TblNames ON TblCountry.ID = TblNames.CountryID
GROUP BY TblCountry.Country
HAVING (((Count(TblNames.CountryID))>0))
ORDER BY Count(TblNames.CountryID) DESC;

Open in new window


I have attached the map so you can see.
regards in advance
ExPatsfromDover.png
PeterBaileyUkAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
Yes, you should set coordinates of markers.
There is author's blog with a lot of samples:
http://wp-osm-plugin.hanblog.net/exsamples/display-marker-file/
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
At present I have a decent png of a map of the world and just edited the totals against each country manually.
You'd need to tell us more about how you did that. Does the map derive information from your database to show the values? If so, can you show how it does that?
0
 
als315Commented:
You can use free OpenStreetMaps plugin for Wordpress:
http://wordpress.org/plugins/osm/
It can show markers from text file, which could be generated from Access and uploaded to your site.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
PeterBaileyUkAuthor Commented:
No The map was just an image and I edited in windows paint the numbers.
0
 
PeterBaileyUkAuthor Commented:
Will the wordpress plugin allow me to map between one country and another?
0
 
PeterBaileyUkAuthor Commented:
Thank you apologies for slow reply, had a hectic week.
0
 
PeterBaileyUkAuthor Commented:
I tried installing the osm product and the google maps but when I try that i get the page that asks for ftp credentials and not sure what to put their.

I am already in the wordpress dashboard.

Wasnt sure either if i needed to post a new question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.