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

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Saturday, March 22, 2008

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

Thursday, March 06, 2008

WizHook - more undocumented functions

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

Monday, March 03, 2008

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: