MS Access DAO recordset + SQL Server: how to get the ID of a newly inserted record Sometimes when inserting records programmatically you want to create a parent record first, then add records into related tables where the Foreign Key is on an autonumber field. Therefore you need to ... read more Posted by Crispin Flower 23 December 2011 Categories: HBSMR MS Access SQL Server VBA Comments(1)
SQL Server 2005: how to allow remote connections When running instances of SQL Server on laptops/PCs, it can be troublesome allowing others on the network to connect to them. Keith Westcott has written up this guide. Obviously paths may need to be... read more Posted by Crispin Flower 08 December 2011 Categories: SQL Server Comments(0)
ArcGIS 10 - tips to improve editing responsiveness If you are experiencing poor performance/responsiveness whilst editing features in ArcGIS v10 this can in many cases be remedied by turning off the new snapping tools, which are on as default in... read more Posted by Steve Ellwood 08 December 2011 Categories: ArcGIS Comments(0)
How to prevent MS Access truncation or mangling of expressions over 255 characters in length There’s a weakness in Access/JET that if a expression outputs a string longer than 255 characters ... read more Posted by Crispin Flower 05 December 2011 Categories: HBSMR MS Access Comments(0)
Wishbox for web site feedback Mike has pointed out a potentially useful tool for our web projects. Wishbox is from the s ... read more Posted by Crispin Flower 23 November 2011 Comments(0)
Some jottings on SQL Azure and GIS I have set up a SQL Azure 90 day trial (as of 18th November) to test whether ArcSquirrel can work ... read more Posted by Crispin Flower 19 November 2011 Categories: ArcGIS Azure GIS (general) GISquirrel MS Access OGR/GDAL Quantum GIS (QGIS) SQL Server Comments(1)
Useful Windows Live Writer plugins Windows Live Writer is a great blog authoring tool that we use with this knowledgebase (a mojoPortal blog + pages). Since we are often posting code snippets, here are a couple of useful plugins. They ... read more Posted by Crispin Flower 17 November 2011 Categories: mojoPortal Visual Studio Comments(0)
Solution Load Manager for Visual Studio 2010 If you have a complicated multi-project solution where Visual Studio 2010 is starting to take a while loading – try adding this extension which by default causes projects to only load on demand.... read more Posted by Crispin Flower 17 November 2011 Categories: Visual Studio Comments(1)
Notes on importing spatial data into SQL Server 2008 There are a variety of ways to do this, but often you will hit issues with data validity. If you have our ArcGIS Maplink product (or ArcSquirrel) then loading data in using this into a... read more Posted by Crispin Flower 17 November 2011 Categories: ArcGIS GIS (general) GISquirrel MapInfo Professional SQL Server Comments(1)
Where to find the Ordnance Survey registration files The registration files (world files and tab files) for all Ordnance Survey raster datasets can be downloaded from: http://www.ordnancesurvey.co.uk/oswebsite/products/geo-referencing.html These are... read more Posted by Crispin Flower 15 November 2011 Categories: ArcGIS GIS (general) MapInfo Professional Comments(0)