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

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Monday, November 13, 2017

Happy birthday, Microsoft Access!

25 years ago, November 13, 1992, Access 1.0 was relased, and almost the same time I started to work with it! Long life, Mr. Access!

Here some introductionary words from its father, Bill Gates:


Tuesday, March 28, 2017

Access Web Apps–the end?

We no longer recommend Access Services for new apps. This feature will be retired from Office 365. We will stop creation of new Access-based apps in SharePoint Online starting June 2017 and shut down any remaining apps by April 2018.

Labels: ,

Friday, January 20, 2017

SSE Setup

SSE Setup is a freeware Windows installation creator, looks interesting: works on most Windows OS, 32 and 64 bit, non-admin and UAC-friendly installs, etc. And of course - Easy Access database deployment!


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.



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


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