How to link SQL Server / RDBMS tables into MS Access without a DSN Linking tables from RDBMS like SQL Server into an Access front end doesn't need an ODBC DSN to be configured, it can be done with a one-liner. I’m just posting this here because I keep having to look ... read more Posted by Crispin Flower 30 March 2017 Categories: MS Access SQL Server Comments(0)
How to do a typeahead incremental search control in Microsoft Access When a user needs to find an existing record or value by typing something in a box, it is well recognized that a "typeahead" or incremental search is a powerful and user-friendly solution. Of... read more Posted by Crispin Flower 11 January 2015 Categories: MS Access UXD VBA Comments(7)
Handling different character encodings when importing tabular data from CSV I’ve been fixing some minor issues with the utility in HBSMR that imports data from the Portable Antiquities Scheme. One issue was that some characters were mojibaked during the import, for example... read more Posted by Crispin Flower 24 September 2012 Categories: HBSMR MS Access VBA Comments(0)
Windows updates break MS Common Controls Tree Control This is a replacement blog-post, based on our developing understanding of the problem and users' experiences. It appears that the update that disrupts the operation of 'tree' controls in HBSMR v3 and ... read more Posted by Crispin Flower 16 August 2012 Categories: HBSMR Microsoft Office MS Access Comments(0)
Adding files to a SharePoint document list with MS Access – how to add new files MS Access can be a nice interface onto SharePoint. We’ve been implementing this for a client, allowing files and metadata that are managed in HBSMR (Access UI onto SQL Server database) to be... read more Posted by Crispin Flower 01 February 2012 Categories: MS Access SharePoint VBA Comments(0)
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)
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)
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)
How to query remote databases in MS Access It is possible to point a query at a table in a remote database that is not linked to the current database; for example this would transfer the some of the fields from a remote copy of the Northwind... read more Posted by Crispin Flower 07 April 2010 Categories: MS Access Comments(0)
Setting up ODBC data sources on 64-bit Windows Server 2008 / Windows 7 Windows Server 2008 x64 and Windows 7 x64 have both 32 bit ODBC data sources and 64 bit ODBC data sources. They are managed separately. Setting up a 32 bit ODBC connection in Windows Server 2008 x64. ... read more Posted by Crispin Flower 30 December 2009 Categories: MS Access Comments(0)