How to know Microsoft Access Database File Version

Enable the macro VBA (Visual Basic Application)

1. In a Microsoft Office Access program, click the File tab > Access Options button.
2. When the Access Options window is showed. Click Trust Center on the left side.
3. Click Trust Center Settings button.
4. Click Macro Settings on the left side.
5. Check "Enable all macros (not recommended; potentially dangerous code can run).
6. Click Ok button twice.

or you can do this:

1. Open the Microsoft Access database file.
2. When the Message Bar is showed. Click Options button.
3. Click Enable the content.
4. Click OK button.

Running the VBA command

1. Click Ribbon tab "Database Tools".
2. Click Visual Basic.
3. On Microsoft Visual Basic Editor, click View > Immediate Window menu.

4. Type in Immediate Windows:
Print CurrentProject.FileFormat

The result may similar, like some of these following number:
2 = Microsoft Access 2
7 = Microsoft Access 95
8 = Microsoft Access 97
9 = Microsoft Access 2000
10 = Microsoft Access 2003
12 = Microsoft Access 2010, 2007

database management system, dbms

Related Post:

DDL, DQL, DML, DCL and TCL Commands

Microsoft Access SQL Sample

Contoh Desain Tabel Database 1

Common Windows Run Commands 1

Memelihara Kesehatan Lingkungan