Deprecated Database Engine Features in SQL Server 2008 R2

If you are planning to migrate your SQL Server DB to next SQL Server version – check this article: Deprecated Database Engine Features in SQL Server 2008 R2. And even not planning – worth reading it.

Classic VB is 20!

Classic VB is 20 and still missed by many. I also still use VB6, and do not see any replacement. VB functions/classes libraries, ActiveX controls, complex user interface forms – this you can easy build in VB6 and use in Access application. What about you?

Jet Replication Wiki

David Fenton's replication wiki:

What is Jet Replication?
How does Jet Replication work?
Resources for learning about Jet Replication
Replication Wiki Frequently Asked Jet Replication Questions (FAQ)
Things not to believe in the MS documentation
Best Practices

Working with Compressed (zipped) folders in MS Access

How to use Windows Shell object to zip and unzip files – read this article by Doug Steele, Access MVP.

Word 2010 Command Finder

Office-Watch.com: "We’ve become really frustrated with finding a feature in Word, especially in the command list. So we’ve done something about it with the new online Command Finder for Word 2010"

Useful tool! One thing I found frustrating - "now searching all 1,752 commands listed by Word 2010..." takes several seconds, like it is 1,752,000 commands or even more. Interesting – what database they are using? Access can do this much faster :)