How to deploy Access 2003 runtime with SP2/SP3 applied

Tony Toews, Access MVP, mentioned this post - Nested msi with custom action : msp file.

Update: Sascha Trowitzsch, Access MVP, have written a tutorial on how to create the patched runtime.

Ribbon Visual Designer in VSTO

Latest VSTO (Microsoft Visual Studio Tools for the Microsoft Office system) now includes Ribbon Visual Designer, no need to dig in XML now.

FTP Client on Access

A very good sample Easy Uploading/Downloading/Browsing using an FTP server on Stuart McCall's Microsoft Access Pages, as well as other useful Access staff.

 

MSDE/SQL Express concurrent user limit

Does MSDE/SQL Express has a 5 concurrent user limit? Euan Garden clarifies this.

SQL Server 2005 Missing Indexes Feature

Very cool feature for SQL Server 2005 - Missing Indexes Feature.  It uses dynamic management objects and Showplan to provide information about missing indexes that could enhance SQL Server query performance. So you can just run a query to find out which indexes are missing. Of course it can't replace developer or DBA, who certainly knows better how to fine tune DB, but can help to do so.

Here a blog post of Russian MVP Alexander Gladchenko, who pointed me to this feature.

Technorati tags: SQL Server, index

WizHook - more undocumented functions

Something what I did not know yet - WizHook is an internal undocumented library for Access wizards in Access 200 and later. Anyway - not so useful either, most of the functions listed in PDF I have already in VB/VBA.

ActiveX control events

When somebody tries to use ActiveX control events for first time – it looks like ActiveX control has only few events:

But this is just a limitation of Access property sheet, it does not show all events. To get all events you can do the following: open form’s class module in VBE, in left top combo select control name, in right top combo – event you need, and event procedure will be inserted into class module:

Microsoft Access Error Number and Error Description Reference

Microsoft Access Error Number and Error Description Reference, by Luke Chung, President of FMS, Inc.