Try Access 2007 online

Microsoft now offering to run Office 2007 beta on remote environment - Take the 2007 Microsoft Office release out for a test drive!, so you don’t need to install beta software on your PC. Not sure that you can really upload your Access application there in order to test new Access on it, looks like all connections to internet is closed in remote session, and copy/paste between local and remote PC does not work either. But if you want to look at new Office features – this is a great opportunity!

Interesting fact, what Microsoft running Office trial on Citrix server, not using own Terminal server…

Network Traffic Analyzer

Access is very sensitive to the quality of the network. Once you have one bad network card on your network – and it can cause frequent corruptions of database. Personally I recommend using managed switch in network environment, where you can see which card produces errors. But there is also software solution, I just learned from Microsoft Public Newsgroups discussion - Ethereal® network analyzer. Did not use it yet, but once I get chance to do so – will publish results here.

AutoCorrectOff Add-in

As you already noticed – I was recently hit several times by Name AutoCorrect option. So I decided to solve this issue for myself somehow, and I made an add-in, which switches Name AutoCorrect feature for any opened database. I like it, and now it is available for free download - AutoCorrectOff Add-in. Hope it will help you also. Comments are welcome.

Database template

Access 2007 introduces an approach, similar what we know as Word or Excel templates. According to Erik Rucker post you can create a database with common settings, which will be used as a temple for new databases. Cool!

Database Issue Checker Utility

Allen Browne, Access MVP, has released a quite useful utility for Access developers - Database Issue Checker. It helps to identify problems with your database such as reserved words in object naming, missing Primary Key, orphan foreign keys, etc. Check it out!

Access Tips and Tricks page

As you already noticed – I use this blog also to post tips and tricks on Microsoft Access. I think blog it a good place for such kind of stuff, except one thing – could be difficult to find something. Actually I have difficulties myself to find anything on my blog, as Google search shows archive, combined pages instead actual. So I decided to make Microsoft Access Tips and Tricks page, hosted on Point Limited site, with categorized list of all useful posts of this blog. Hope it will help you!

One more free installation system

NSIS - Nullsoft Scriptable Install System. And one more great resource - Windows Installer Authoring Tools for Developers

Access 2007 Limits

Erik Rucker has posted Access 2007 Limits data, looks like no major improvements from last version...

Latest MDAC Component Checker

MDAC Component Checker helps you determine installed version information and diagnose installation issues with Microsoft Data Access Components (and ADO).