Microsoft Access Acronyms
I spent five years as an officer in the United States Army. Let me tell you, the Army loves acronyms. It wasn't unusual to get emails like the following:
LT,
Submit USR to 125th FSB XO NLT COB.
CO
Translation:
Lieutenant,
Submit Unit Status Report to the 125th Forward Support Battalion Executive Officer no later than close of business.
Commanding Officer
While that may be a bit extreme, it's not too far off from many military communications. There is a strong case to be made for the higher signal vs. noise ratio in the first example compared to the second, but only if you know what all the acronyms stand for.
Acronyms in the Access World
To help you navigate the acronyms you may come across in the course of your Access development career, I'm going to gather some of them here.
These are not the most common acronyms that you will come across. Some are quite common, like "ODBC," while others are more obscure, such as "DDE." All of them are in some way related to Microsoft Access development.
- ACE: Access Connectivity Engine
- ADO: ActiveX Data Objects
- BOF: Beginning of File
- COM: Component Object Model
- CRUD: Create, Read, Update, Delete
- DAO: Data Access Objects
- DDE: Dynamic Data Exchange
- DDL: Data Definition Language
- DML: Data Manipulation Language
- EOF: End of File
- ISAM: Indexed Sequential Access Method
- JET: Joint Engine Technology
- LOB: Line Of Business [application]
- MOTW: Mark of the Web
- MVF: Multi-Valued Field
- ODBC: Open DataBase Connectivity
- SQL: Structured Query Language
- VBA: Visual Basic for Applications
Let me know in the comments if I left any out that you think deserve a mention.
COM-Related Acronyms
The world of COM is a wild and woolly place with an overwhelming smorgasbord of alphabet soup. Learning the acronyms associated with COM is an important first step in learning COM itself:
- OLE: Object Linking and Embedding
- OCX: OLE Control eXtensions
- DLL: Dynamic Link Library
- MSVBVM60: Microsoft Visual Basic Virtual Machine 6.0
Access-Related File Extensions
The following extensions apply to Microsoft Access databases written in the Access 2003 and earlier file format:
- LDB: Lock file for Access Database
- MDB: Microsoft Access Database
- MDE: Microsoft Access Database, Execute-only
Microsoft introduced several new file formats available in Access 2007 and later:
- ACCDB: Access Database
- ACCDC: Access Database Container
- ACCDE: Access Database, Execute-Only
- ACCDR: Access Database, Runtime-Only
- ACCDT: Access Database Template
- LACCDB: Lock file for Access Database
Referenced articles
UPDATE [2022-01-30]: Added section on Microsoft Access-related file extensions (h/t Richard Rost).
UPDATE [2022-02-14]: Added Mark of the Web acronym (MOTW).
UPDATE [2022-03-05]: Added section on COM-related acronyms (OLE, OCX, DLL).
UPDATE [2022-05-14]: Added Microsoft Visual Basic Virtual Machine acronym (MSVBVM60.dll).