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

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

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

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

We’ve had a bit of bother over the past few weeks, where an Access application compiled as an .accde file in Access 2010 would not run on other machines. The error messages encountered varied... read more

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

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

There’s a weakness in Access/JET that if a expression outputs a string longer than 255 characters

... read more

I have set up a SQL Azure 90 day trial (as of 18th November) to test whether ArcSquirrel can work

... read more

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