I.T. Discussion Community!
-Collapse +Expand
Search Access Group:

-Collapse +Expand Access To/From
-Collapse +Expand Access Store

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► KBDesktop Data...Access & VBAAccess VBALanguage Basics   Print This     
  From the June 2015 Issue of Prestwood eMag
Access Language Basics:
Access VBA File Extensions (.MDB)
Posted 12 years ago on 3/5/2008 and updated 1/13/2009
Access Code Snippet:
 A flashcard from our Access Flashcards Library
 A code snippet from our Access Code Snippets Page


Languages Focus: File Extensions

Common or primary file extensions used (not a complete list, just the basics).

Access VBA File Extensions

  • .MDB - Access Database
  • .MDE - Protected Access Database

More Complete List:

File extensions changed from Access 2003 to 2007.

Microsoft Access 2003 and earlier primary file extensions:

  • .mdb - Access Database
  • .mde - Protected Access Database with compiled VBA

Microsoft Access 2007 primary file extensions:

  • .accdb - Access Database
  • .accde - Protected Access Database with compiled VBA

Other file extensions created by Access:

  • .adn - Access Blank Project Template
  • .adp - Access Project
  • .maf - Windows Shortcut: Access Form
  • .mam - Windows Shortcut: Access Macro
  • .maq - Windows Shortcut: Access Query
  • .mar - Windows Shortcut: Access Report
  • .mat - Windows Shortcut: Access Table
  • .mda - Access Database, used for addins (2,95,97), previously used for workgroups (2).
  • .mdf - Access (SQL Server) detached database (2000)
  • .mdw - Access Workgroup, database for user-level security.

More Info


Share a thought or comment...
Write a Comment...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1253A1
Enter key:
Code Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

 KB Article #100913 Counter
Since 4/2/2008

Follow PrestwoodBoards on: 

©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech