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

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, October 29, 2009

How to relink Access tables faster

When you run relink procedure at application startup, and backend file is located on the network – the process can be much slower then relinking local file, even with very fast network. The trick is to open backend file before relink process and close it after. Sample code:

Dim dbData  As DAO.Database
Set dbData = DBEngine.OpenDatabase(strFileName)
'Relink proc follows
Set dbData = Nothing

Labels: ,

Access 2010 in action

Check out this great video - Access 2010 and Outlook style calendar running in a browser by Albert D. Kallal, Access MVP. Application was developed in Access and running in web browser using SharePoint Access services. Well done, Albert!


Wednesday, October 21, 2009

Access 2010 - Access Services

Now it is official - Access Services for Sharepoint 2010. Ryan McMinn and Clint Covington opens curtain.


Thursday, October 01, 2009

MVP 2009

Just got my MVP award:

Congratulations! We are pleased to present you with the 2009 Microsoft® MVP Award

This is my 12th year on MVP, first was in 1998. I feel great!