Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-12-2017, 01:11 PM   #1
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 1,616
Thanks: 28
Thanked 360 Times in 334 Posts
ridders will become famous soon enough ridders will become famous soon enough
A fully searchable UK Postcode database

Attached is a fully searchable database of all current UK postcodes.
This provides more info than you'll ever need to know about each postcode together with a map of the location (from Google maps)



ONLY the frontend database is attached - save this to a TRUSTED location.

Next download the backend postcode datafile:
There are around 2.5 million UK postcodes so the backend postcode datafile is VERY large.
It is freely available at www.doogal.co.uk and is frequently updated.
You will need to download this datafile yourself (as a zipped MDB file) as it is FAR too big to upload here.
The file size is approx 93 MB zipped & 950 MB unzipped

Unzip the file into the same folder as this frontend.

INSTRUCTIONS:
Hold the SHIFT key down while you open the front end
Relink the table 'Postcodes' to the backend datafile
Close & reopen the frontend normally..
The main form opens automatically

I have used the Google Maps API for this database.

The 'static' postcode map is created instantly (unless your broadband connection is very slow) as an image file Map.bmp in the same folder

I have provided a settings form where you can customise the map created
e.g. map size, zoom level, marker colour etc

For further info, see this link:
https://developers.google.com/maps/d...tic-maps/intro.

You should obtain your own API key from this site
The API is free up to a limit of 25,000 map loads per 24 hours and with a 640 x 640 maximum image resolution (both should be more than enough here).

Another version of the main searchable postcode form is also provided if you wish to try it.
This allows you to view the location on a 'live' map so that you can move around on the map.
Choose from using an internal web browser window or an external browser

In the past, Multimap was excellent for this purpose but it no longer exists.
I have tested several options for the live map: Bing / Google / Michelin / Open Street Map with varying results.

Choose the map provider that works best for you
Overall, I found Open Street Map by far the best and its open source software.





NOTE:
To update the data at a later date, just replace the backend database with a new version from the website

UPDATE 13/08/2017
The database expects to find a file called Map.bmp in the same folder.
If its missing you wil get an error message.
Either create a file with that name or download the attached (zipped) example
Attached Images
File Type: png Form.PNG (99.3 KB, 151 views)
File Type: jpg OnlineMap.jpg (88.2 KB, 152 views)
File Type: png MapProviders.PNG (15.2 KB, 138 views)
Attached Files
File Type: zip UKPostcodeInfo.zip (117.3 KB, 33 views)
File Type: zip Map.zip (21.5 KB, 19 views)

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 08-13-2017 at 05:12 AM.
ridders is offline   Reply With Quote
Old 08-13-2017, 01:39 AM   #2
ypma
Newly Registered User
 
Join Date: Apr 2012
Location: Southamton England
Posts: 466
Thanks: 20
Thanked 74 Times in 74 Posts
ypma is on a distinguished road
Re: A fully searchable UK Postcode database

Thank you Ridders , for posting the searchable postcode db. It provides plenty of information , but not a road name. I known larger roads are named on the map but not the small ones .

Thank again

Regards Ypma
ypma is offline   Reply With Quote
Old 08-13-2017, 08:23 AM   #3
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 1,616
Thanks: 28
Thanked 360 Times in 334 Posts
ridders will become famous soon enough ridders will become famous soon enough
Re: A fully searchable UK Postcode database

@ypma

It contains all the information contained in the online postcode database.
Road names are not included in that so aren't in mine. Nor are house names/numbers for the same reason.

However if you use the settings form to increase the zoom on the map from default value 15 to 17 you should be able to see all street names on the map.
Or use the ALT version of the form which uses an online map instead.

You can obtain full address information separately for individual postcodes online.
However if you want street names and possibly house names for all postcodes you have to pay for the data
See this thread for more info https://www.access-programmers.co.uk...d.php?t=295235

I'm considering creating a 'deluxe' version of this database to include that data for various postcodes ... if there is a demand for it.
However I would have to charge for it to cover both my development time and costs of downloading the data.
If you are interested in this idea, please send me a private message

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 08-14-2017 at 04:51 AM. Reason: extra info
ridders is offline   Reply With Quote
Reply

Tags
google maps api , uk postcodes

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Searchable database tanc Web Design and Development 6 05-20-2016 08:47 AM
Question Searchable Artwork Database nrego General 2 09-28-2012 10:02 AM
Need help with creating searchable database! abw1987 Forms 5 08-05-2009 10:41 AM
Building first real (easy I think) database - is this design fully functional? sindyr General 13 10-26-2008 08:57 AM
Making a searchable database 113deluxe Queries 1 06-16-2003 05:08 AM




All times are GMT -8. The time now is 02:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World