Error: Could not use file already in use

There might be a time when you want to open database and you came across an error " could not use file [file name] file alrea...

How to turn off security warning in MS Access

When developing MS Access Application, MS Access 2007 will come with VBA Macro disabled. You will not be able to run MS Access VB Code if t...

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...

Solution for Property not Found error on BeforeUpdate event

Property not Found error will occur when you want to cancel the value update on BeforeUpdate event in MS Access Form. When you set the Can...

A little bit of my background on MS Access

Here are my brief background related to MS Access. I really started working with MS Access in the year 2000. However, my MS Access learning...