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