News, links, downloads, tips and tricks on Microsoft Access and related
Tuesday, March 28, 2017
Friday, January 20, 2017
Wednesday, November 09, 2016
MS Access Right-Click Context Menu Creator
Wednesday, June 15, 2016
Access WizHook library
Wednesday, May 11, 2016
Access SQL Editor
Tuesday, April 26, 2016
Meet SQL Server 2016
SQL Server 2016 Release Candidate 3 was released recently, amoung other new features - temporal tables: a system-versioned table allows you to query updated and deleted data, while a normal table can only return the current data.
These are the most common use cases for temporal tables:
- Audit. With temporal tables you can find out what values a specific entity has had over its entire lifetime.
- Slowly changing dimensions. A system-versioned table exactly behaves like a dimension with type 2 changing behavior for all of its columns.
- Repair record-level corruptions. Think of it as a sort of back-up mechanism on a single table. Accidentally deleted a record? Retrieve it from the history table and insert it back into the main table
See Introduction to SQL Server 2016 Temporal Tables for more info
Saturday, February 20, 2016
Add-ins for Access web apps
Create add-ins for Access web apps – step through the process
Latest Microsoft Office Developer Tools for Visual Studio 2015 - link to the latest Microsoft Office Developer Tools for Visual Studio 2015
Office UI Fabric
Office 365: Bind and manipulate data in a SharePoint Access app
Have more links? Write me in comments