Microsoft Access Technical Articles

Data Export Made Easy

This article demonstrates an utility that handles exporting the data behind any currently active MS Access object to any of the MS Access-supported formats. Your users should find just about every option they need in this portable utility.

Using FTP from MS Access Applications

We live in a "connected" world - almost every system has to exchange data with other systems. One of the oldest and most widespread communication protocols is FTP. In this article, I'll show how you can incorporate FTP access into your applications.

Implementing multi-language applications in Microsoft Access

Internationalizing your application can mean using locale-specific number and date/time settings, among other options. Many of those options are controlled in Windows by the user's environment settings. For the user interface, string resources can be built into the compiled application (usually into the EXE) to support swapping in different sets of text. These resources are usually hard-coded into the application file at compile time. If an application needs to be deployed in different languages, different application files need to be compiled and deployed.

Dealing with File Names in MSAccess Applications

Microsoft Access applications can use Jet databases, other databases (as linked tables), or SQL Server. But sometimes you need to work with files on your hard disk. This article will provide you with every function that you'll need to work with file names - including converting from UNC names to mapped drives (and back again).