In an effort to remain simple, the Access export to text file wizard manages to do the opposite, making simple updates to export specs unnecessarily cumbersome.

For one-off text file data imports, it's hard to beat the simplicity of Microsoft Access's built-in wizard.

An introduction to the differences between local and linked tables in Microsoft Access, including five situations where local tables are the better choice.

When are two identical values not equal? When they're both Null! If you are a Microsoft Access developer, you need to understand how (and why) this works.

Bookmark this handy reference so the next time you come across an Access acronym that you don't recognize, you will have a quick way to look it up.

A simple Windows API call makes for a reliable and efficient way to pause your VBA code. Much better than a "do-nothing loop."

Looking for a quick and simple way to loop through a list of strings? These 4 lines of code are all you need.