News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Wednesday, May 11, 2016

Access SQL Editor

Access SQL Editor – quite useful add-in for Microsoft Access (where we still have such a basic SQL editor, no changes since version 1,0!), allows you to save formatted SQL queries in a Microsoft Access (Jet/ACE) database, with syntax highlighting and comments.



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

A friend of mine has recently tried to create add-in for Access web app (AWA). Here some links and tips, can be useful once you decide to do the same.
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
JavaScript API for Office
Office UI Fabric
Office 365: Bind and manipulate data in a SharePoint Access app
Create JavaScript web apps using CORS to access Office 365 APIs

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":

How do I get the newest features in Office 2016 for Office 365?

Wednesday, December 09, 2015

Access 2016 Runtime

… is out! The Microsoft Access 2016 Runtime enables you to distribute Access 2016 applications to users who do not have the full version of Access 2016 installed on their computers.

Labels: ,

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.



Wednesday, November 18, 2015

Access 2016 VBA CHM file

Access 2016 VBA CHM file now made available for download (as well as Word, Excel and PowerPoint), if you need it while offline. Don't forget to unblock it (see Troubleshooting)!