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

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Wednesday, September 29, 2010

Access 2010: Interactive menu to ribbon guide

The most popular post in this blog is Compact database in Access 2007, people really get lost in Ribbon. Access 2010 has better organized Ribbon, but still - transition from Access 2003 to 2010 is not so easy due to the Ribbon. Microsoft just posted new program to help new Access 2010 users - Interactive menu to ribbon guide. Look how it shows where Compact database menu item in Access 2010:


Fortunately in Access 2010 Compact and Repair Database item was moved in more intuitive place:


Labels: ,

Thursday, September 23, 2010

SQL Script Generator

Just found another SQL Script Generator instead of my favorite SQL Scripter, which is not free anymore. Works fine, and free. Do you have better suggestions?


Tuesday, September 21, 2010

A Soundex Search for Access Web services

A great article by Albert D. Kallal, Access MVP, shows how you can port VBA code to data macros to be used in Access web services.


Thursday, September 16, 2010

VBA Hover ToolTip Trick

Nice VB/VBA trick - you can hover over variable in VBE, holding Ctrl key down - and you will see last 77 characters of long string, more details at BaconBits.

Labels: , ,

Wednesday, September 01, 2010


Microsoft have recently came up with new product - Microsoft Visual Studio LightSwitch – a set of tools to create applications to run on web, desktop and cloud. Looks interesting, but why one need to have such application? Web application in the cloud can work for any business, if somebody concerns on cloud security – he can put local web server or cloud in his office. But running same application as desktop and web – I do not see any advantage. Any clues?

Another feature – LightSwitch can work with different data sources, it is good. But still no way to hit Access, which can work with wider range  of data sources! :)