Subscribe: Alex & Access
Added By: Feedage Forager Feedage Grade A rated
Language: English
access sql  access  microsoft access  microsoft  office  server express  server  sql server  sql  update  version  web  windows 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Alex & Access

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

Last Build Date: Thu, 20 Oct 2016 03:55:59 PDT


Access WizHook library

Mon, 20 Jun 2016 00:54:51 PDT

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

Access SQL Editor

Wed, 11 May 2016 07:43:22 PDT

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.



Meet SQL Server 2016

Tue, 26 Apr 2016 02:20:02 PDT

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


Add-ins for Access web apps

Fri, 19 Feb 2016 23:58:55 PST

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

How Office 365 users get Office updates

Mon, 11 Jan 2016 01:34:35 PST

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?


Access 2016 Runtime

Wed, 09 Dec 2015 06:26:19 PST

… 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.


How to automate entering VBA password

Mon, 30 Nov 2015 03:55:43 PST

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.



Access 2016 VBA CHM file

Wed, 18 Nov 2015 02:32:20 PST

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)!


ADP+ for Access 2013 with SQL Server

Thu, 12 Nov 2015 04:12:51 PST

Another way to connect Access and SQL server - ADP+ library from Joakim Dalby, Denmark. Looks like it is build on ADO, and should work the same way as Access ADP. Would be good to know if anybody tried it?

I personally use  linked tables and DAO/pass-through tables, tried to use ADP several times, but every time switched back to mdb.


Access UserVoice

Tue, 13 Oct 2015 01:44:07 PDT

Access on UserVoice  - suggest ideas and vote for others feedback. Access team promised to monitor this site :)


Access Lunchtime user group

Thu, 17 Sep 2015 02:52:13 PDT

Access MVPs Juan and Ben staring "Lunchtime" online Access user group at September 29th, mark your calendars and join it last Tuesday of the month at 12 noon CDT!

Details are here Access Lunchtime


Known issues with Office and Windows 10

Wed, 16 Sep 2015 02:19:35 PDT

Following article is a list of known issues with Office and Windows 10, planned to be kept up-to-date:

Known issues with Office and Windows 10


SQL Server version comparison and OS compatibility

Tue, 08 Sep 2015 05:43:01 PDT

Good to check when you are planning to upgrade Windows or SQL Server:

Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads


July 2015 Access updates

Thu, 16 Jul 2015 06:18:20 PDT

July 14, 2015, update for Access 2013

Fixes the following issues:

- When you open multiple objects in design view and then try to switch to another view in Access 2013, Access 2013 may become unresponsive.

- When you undo a column deletion operation in table design view in Access 2013, Access 2013 crashes.

- The Conditional Formatting button does not work if the ribbon is collapsed in Access 2013.

- After you import a form or report or you copy and paste an existing form or report in an Access app, the theme colors are changed unexpectedly under the control of the newly created form or report.

July 14, 2015, update for Access 2010

Fixes the following issue:

When you start Microsoft Access 2010 on a computer that has not been restarted for a long time (for example, 24 days), the CPU usage of the MSACCESS.EXE process becomes high. However, applying this update will reintroduce the problem that is addressed by the hotfix KB2899528 for Access 2010 November 11, 2014. As soon as this update is installed, fields that are bound to expressions on forms may not be recalculated when the computer has not been restarted for a long time.


Office 2016 Preview

Mon, 22 Jun 2015 01:10:32 PDT

There is a great opportunity to join Office 2016 Preview program, so you can learn and try its new features!


How To Migrate Data from Desktop to Access App

Thu, 11 Jun 2015 03:36:12 PDT

Tutorial video from Crystal, Access MVP, helps you to understand migration process to Access App, if you never done this before.



ADP+ framework for Access

Wed, 03 Jun 2015 01:52:44 PDT

Missed ADP projects? ADP+ can help you. this is a Data Access Layer for updatable form and subform and for report and subreport to have a client-server rapid ap­pli­ca­tion deve­lop­ment framework in Ac­cess 2013 connected to a SQL Server da­ta­ba­se 7.0, 2000, 2005, 2008, 2012, 2014 and the forthcoming SQL Server 2016.


Using WMI

Fri, 20 Feb 2015 00:14:25 PST

Normally we are using Windows API to access registry, etc. You can a lot of tasks with WMI. The main advantage, as I see, that WMI code works with any Windows version, also 32 and 64 bit, so you don't need to use conditional compilation. Hope it will work on future Windows versions as well…

Here a lot of sample code on how to use WMI for different tasks:

WMI Tasks for Scripts and Applications


Few FMS papers for SQL Server and upsizing

Fri, 06 Feb 2015 02:11:42 PST

Worth reading:

Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads

For the first time, all the different versions of SQL Server Express from 2005 to 2014 are shown, compared, and referenced with download links. I can’t even begin to share how time consuming it was to put this together and go through all the details of which O/S each version supports. Just because Microsoft web pages list the versions they support don’t necessarily mean it works when you actually try to install it. I’m sure there are still some minor inaccuracies among the SP releases. Let me know if you’ve experienced something different from what we’ve listed.

Automating the Backup of Your Microsoft SQL Server Express Databases

If you’re using SQL Server Express, you still need to create backups of the database. Here’s how to automate it which wasn’t easy to discover.

When and How to Upsize Microsoft Access Databases to SQL Server

The original version of this was written when Microsoft selected us to do a joint Access to SQL Server Upsizing campaign a decade ago. I’ve updated it to better explain why and why not people should upsize their Access databases and an overview of what the options are and what to do.

Microsoft Access to SQL Server Upsizing Resource Center

Our new Upsizing site with links to our whitepapers and Microsoft resources that help with the whole upsizing process and use of SQL Server Express.


Getting localized NT AUTHORITY domain name

Wed, 28 Jan 2015 02:13:00 PST

If you are dealing with built-in system accounts, like NT AUTHORITY\SYSTEM, this code can help you on localized Windows versions, where NT AUTHORITY domain is also translated, for example to NT-AUTORITÄT in German version. You can get localized name using it SID "S-1-5-18":


You have to use this function, when you select system object using Object selection dialog as well.


Object selection dialog

Tue, 27 Jan 2015 01:51:08 PST

Object selection dialog (or Directory service Object Picker) can be useful when you need to change user right on file system or SQL server. I never used it before and it took me some time to find the right code, which works in Access and VB - Object picker with dispcallfunc.


Using the Windows 2000/XP Object Selection Dialog article helps to understand parameters of dialog, and Active-Directory-Object-Picker is a .Net version of dialog.


Automate any browser with Selenium VBA

Mon, 05 Jan 2015 00:23:09 PST

You can easy use Internet Explorer to do web tasks from your code, like screen-scraping or filling forms. But other browsers do not have COM interface, so Selenium VBA let you do such tasks with other browsers as well. Basically it provides a COM interface to the popular Selenium web testing tool. What you can do with Selenium VBA:

  • Automate repetitive web browser tasks.
  • Quickly fill a web form multiple times with data from your table.
  • Extract data from a web page into custom table.
  • Take screenshots of a Web site and save them in a PDF file.
  • Use the selenium automation framework .

Security Update MS14-066 causes major performance problems in Microsoft Access / SQL Server applications

Mon, 17 Nov 2014 00:50:40 PST


Update: Switching to "SQL Server Native Client 10.0" ODBC driver helps to avoid performance issues, looks like update has effect on default "SQL Server" driver only


A better ZoomBox

Mon, 23 Jun 2014 03:09:17 PDT

A better ZoomBox - the improved version of Access Shift+F2 zoom feature by Tom van Stiphout, Access MVP.