Computing, GIS and Archaeology in the UK

I had some interest in the Access module for converting Ordnance Survey NGRs to Eastings and Northings (and vice versa) so I thought I’d risk putting the database on the site for download. It’s in Access 97 but should translate up to newer versions without much trouble.

I should also add that several people commented last week about an online NGR converter that looks really handy, and this excel spreadsheet full of handy vba functions for conversion offline.

Obviously this database is offered with no warranty: it has been scanned for viruses but I won’t be responsible for any damage done to you, your computer, pets, family, work colleagues, friends etc whilst using it. Other than that, you can share it, alter it or otherwise hack it to pieces. A little linkage back to here would be appreciated if it’s useful though!

Where is it? Here

Access 97 is still a popular choice for databases (especially in archaeology!) but the default ArcGIS 9.2 geodatabase is in Access 2000 format and cannot be opened in earlier versions of Microsoft Access. It is possible to create a geodatabase that can be used by both programmes.

1. Create a blank database in Microsoft Access 97 and save it to the location where you want your geodatabase to be stored. Close Access
2. In ArcCatalog, navigate to the database, and right-click to add a new object. Choose “table” rather than “feature class” or any of the other options.
3. Create a simple table called”test”, or similar- you can delete in in a minute. This creates all the geodatabase-specific tables that you need in the database.
4. Import your spatial data into the geodatabase, or create new data as required. You should now be able to access the data in both Microsoft Access and ArcGIS.

As always with geodatabases- do not delete geodatabase tables or feature classes in Access as they will remain visible in ArcCatalog. Only use ArcCatalog for deletions.