News, links, downloads, tips and tricks on Microsoft Access and related
Wednesday, May 11, 2016
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
Monday, January 11, 2016
How Office 365 users get Office updates
How and when do you get update to your Click-To-Run subscriptions through Office 365? Following article will explain that "mystery":
Wednesday, December 09, 2015
Access 2016 Runtime
Monday, November 30, 2015
How to automate entering VBA password
VBA project password can't be considered as strong protection, but sometimes you have to use it. Unprotecting VBA Project Password article shows a sample code to unprotect project, if you know the password. Same technique can be useful when you need to interact with other programs, which you can't automate with OLE or any other interface.