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

...

 

dbData.Close

Set dbData = Nothing

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!

Access 2010 - Access Services

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

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!