Prestwood IT: Access VBA File Extensions (.MDB) (Microsoft Access)

Access

	Access Group Home
Get Started Page eMag: Access Edition Highlights WEEKLYLESSON Week 3 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	Access KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles Access News Resource Links ACCESSTIDBITS: All as FlashCards Code Snippets FAQs Tips

	Access To/From
To/FromCODEGuides Access To/From

	Access Study Test
PRESTWOODCERTIFIED Access Study Test

	Access Store
PRESTWOODSTORE Store Home Buy Access Items

	Members Only
MEMBERSONLY Access Member List Member Only KB Posts Access Content Stats Random Article Random MB Thread Random Tidbit Random CrossRef Code

Prestwood eMagazine

January Edition

Subscribe now! It's Free!

► KB ► Desktop Data... ► Access & VBA ► Access VBA ► Language Basics

Print This

From the June 2015 Issue of Prestwood eMag

Access Language Basics:

Access VBA File Extensions (.MDB)

By Mike Prestwood

Posted 17 years ago on 3/5/2008 and updated 1/13/2009

Access Code Snippet:

To/From Code Guide: Access VBA File Exte... vs. Other Languages

A flashcard from our Access Flashcards Library

A code snippet from our Access Code Snippets Page

Tags: Access VBA , File Extensions

KB100913

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

Comments

0 Comments.

Share a thought or comment...

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

11950

Since 4/2/2008