How to turn off warning message to confirm when doing update, insert, delete in MS Access

When you are doing DML query in MS Access, you will normally get the confirmation message. If you don't want this message to pop up, her...

How to update External MS Access table

When linking to external MS Access DB without table link, you may have some problem updating, deleting or inserting the records. The solut...

How to link read only table from external MS Access

There are times when you need to link table from external MS Access, and MS Access does support that functionality. It can also support m...

VBA Code Does Not Work On ACCDE File

I once have experienced the very strange behavior of MS Access 2007, the one that didn't exist in the previous version. The strange thin...

Option Explicit

One of another best practice for MS Access programming is to use  Option Explicit.  Place Option Explicit on the top of each module Fo...

MS Access Error Exception

Basic MS Access Error Exception When you are coding, the best programming practice is always include error exception in your code. In MS A...

MS Access Tables and Relationships

Access 2007 Tutorial Tables and Relationships This is the video from youtube.com that teaches basic MS Access. This tutorial video teaches...