AccessBlog.net

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

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Wednesday, November 09, 2016

MS Access Right-Click Context Menu Creator

Context Menu Creator - useful tool to create Windows Explorer file context menu like Compact, Decompile, Open Exclusively for desired Access file exnetsions.

WindowsExplorer_AccessDatabase_ContextMenu01[1]

Labels:

Wednesday, June 15, 2016

Access WizHook library

As old links to WizHook - more undocumented functions are gone, posting here a new one: WizHook Overview.

Plus I saved copy here

One more link, documented by Thomas Möller, Access MVP

Labels:

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.

Capture

Labels:

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

Labels:

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