> ## Content Index > Fetch the complete content index at: https://nolongerset.com/llms.txt > Use this file to discover other available public pages before exploring further. # Microsoft Access Acronyms - URL: https://nolongerset.com/microsoft-access-acronyms/ - Published: 2022-01-29T04:11:20.000Z - Updated: 2026-05-08T12:57:36.000Z - Description: Bookmark this handy reference so the next time you come across an Access acronym that you don't recognize, you will have a quick way to look it up. - Author: Mike Wolfe - Tags: Basic, #Import 2026-05-20 02:59 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](https://nolongerset.com/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](https://en.wikipedia.org/wiki/Access%5FDatabase%5FEngine) - **ADO**: [ActiveX Data Objects](https://docs.microsoft.com/en-us/sql/ado/microsoft-activex-data-objects-ado?view=sql-server-ver15) - **BOF**: [Beginning](https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset-bof-property-dao) [of File](https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/bof-eof-properties-ado?view=sql-server-ver15) - **COM**: [Component Object Model](https://nolongerset.com/what-the-heck-is-com/) - **CRUD**: [Create, Read, Update, Delete](https://en.wikipedia.org/wiki/Create,%5Fread,%5Fupdate%5Fand%5Fdelete) - **DAO**: [Data Access Objects](https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-data-access-objects-reference) - **DDE**: [Dynamic Data Exchange](https://en.wikipedia.org/wiki/Dynamic%5FData%5FExchange) - **DDL**: [Data Definition Language](https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/data-definition-language) - **DML**: [Data Manipulation Language](https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/data-manipulation-language) - **EOF**: [End](https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset-eof-property-dao) [of](https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/bof-eof-properties-ado?view=sql-server-ver15) [File](https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/eof-function) - **ISAM**: [Indexed Sequential Access Method](https://en.wikipedia.org/wiki/Extensible%5FStorage%5FEngine) - **JET**: [Joint Engine Technology](https://en.wikipedia.org/wiki/Access%5FDatabase%5FEngine) - **LOB**: [Line Of Business \[application\]](https://en.wikipedia.org/wiki/Line%5Fof%5Fbusiness#Computer%5Fapplications) - **MOTW**: [Mark of the Web](https://nolongerset.com/motw-blocks-all-vba/) - **MVF**: [Multi-Valued Field](https://support.microsoft.com/en-us/office/create-or-delete-a-multivalued-field-7c2fd644-3771-48e4-b6dc-6de9bebbec31) - **ODBC**: [Open DataBase Connectivity](https://docs.microsoft.com/en-us/sql/odbc/microsoft-open-database-connectivity-odbc?view=sql-server-ver15) - **SQL**: [Structured Query Language](https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-access-sql-reference) - **VBA**: [Visual Basic for Applications](https://en.wikipedia.org/wiki/Visual%5FBasic%5Ffor%5FApplications) 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](https://en.wikipedia.org/wiki/Object%5FLinking%5Fand%5FEmbedding) - **OCX**: [OLE Control eXtensions](https://en.wikipedia.org/wiki/Object%5FLinking%5Fand%5FEmbedding#OLE%5Fcustom%5Fcontrols) - **DLL**: [Dynamic Link Library](https://en.wikipedia.org/wiki/Dynamic-link%5Flibrary) - **MSVBVM60**: [Microsoft Visual Basic Virtual Machine 6.0](https://www.file.net/process/msvbvm60.dll.html) ## 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](https://docs.microsoft.com/en-us/office/troubleshoot/access/lock-files-introduction) - MDB: [Microsoft Access Database](https://support.microsoft.com/en-us/office/which-access-file-format-should-i-use-012d9ab3-d14c-479e-b617-be66f9070b41) - MDE: [Microsoft Access Database, Execute-only](https://docs.microsoft.com/en-us/previous-versions/office/aa172702%28v%3doffice.11%29) Microsoft introduced several new file formats available in **Access 2007 and later**: - **ACCDB**: [Access Database](https://support.microsoft.com/en-us/office/deploy-an-access-application-7bb4f2ba-30ee-458c-a673-102dc34bf14f) - **ACCDC**: [Access Database Container](https://support.microsoft.com/en-us/office/deploy-an-access-application-7bb4f2ba-30ee-458c-a673-102dc34bf14f#bm3) - **ACCDE**: [Access Database, Execute-Only](https://support.microsoft.com/en-us/office/deploy-an-access-application-7bb4f2ba-30ee-458c-a673-102dc34bf14f#bm3) - **ACCDR**: [Access Database, Runtime-Only](https://support.microsoft.com/en-us/office/deploy-an-access-application-7bb4f2ba-30ee-458c-a673-102dc34bf14f#bm3) - **ACCDT**: [Access Database Template](https://docs.microsoft.com/en-us/openspecs/sharepoint%5Fprotocols/ms-accdt/0a4a68d7-7a85-4a27-ad74-730db57862d7) - **LACCDB**: [Lock file for Access Database](https://docs.microsoft.com/en-us/office/troubleshoot/access/lock-files-introduction) --- ### Referenced articles [Signal vs. NoiseMy approach to software development in four words: Less noise. More signal.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/10/signal-vs-noise-v2-twitter-1.png)](https://nolongerset.com/signal-vs-noise/) *Image by [Rozbooy](https://pixabay.com/users/rozbooy-12789792/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=5064697) from [Pixabay](https://pixabay.com/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=5064697)* ***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).*