MS Access Programmer

MS Access tips and tricks: database design, VBA programming

MS Access Tips and Tricks for database design, administration, tables, forms, queries, reports and VBA. Written for both the novice and and advanced user.

Access 2007 and 2010 Security Settings

Thumbnail image for Access 2007 and 2010 Security Settings

Instructions on how to disable MS Access security warnings on our computer, as well as an explanation as to why those warnings are there.

Read the full article →

MS Access VBA: Add XML Escape Codes

Thumbnail image for MS Access VBA: Add XML Escape Codes

How to check whether an XML text string requires escape codes and how to insert them using VBA.

Read the full article →

MS Access FTP using VBA

Thumbnail image for MS Access FTP using VBA

Access VBA example that shells out to the DOS program FTP.EXE and uploads a file to an FTP site.

Read the full article →

How To Repair Corrupted Access DB

Thumbnail image for How To Repair Corrupted Access DB

How to fix most Access Database corruption problems. Expert assistance available if needed.

Read the full article →

How To Prevent Access Corruption

Thumbnail image for How To Prevent Access Corruption

Six tips on how to prevent Access Database Corruption.

Read the full article →

Two Digit State Codes for MS Access

Thumbnail image for Two Digit State Codes for MS Access

List of two digit state codes for use in a drop-down box in Microsoft Access.

Read the full article →