MS Access Dump Format

About

Through the COM interface it is possible to dump internal resources (e.g. forms, macros, queries, reports etc.) of a Microsoft Access application into separate files[1]. This allows to develop a Microsoft Access application with multiple developers simultaneously. To ease the handling of such files this VSCode extension provides syntax highlighting for this custom dump format.

Call for Sponsorship

This is a free extension. If you find it useful to yourself or your business then you might consider sponsoring it.

Feature Overview

• Syntax highlighting for MS Access dump format (forms, macros, queries, reports)
• embedded syntax highlighting for SQL and Visual Basic
• breadcrumbs support
• color picker
• encoding of the PrtDevMode(W) block

Syntax highlighting

This extension has syntax highlighting and breadcrumbs support so that the content can be analyzed more quickly.

PrtDevMode(W)

You can hover over the PrtDevMode(W) block to display the information stored there.

File Association

This extension has a predefined file association for the following file endings: *.form, *.mac, *.qry, *.report. If your project uses different file endings you can also add new file association in settings.json, e.g.:

{
  "files.associations": {
    "*.frm.txt": "access-dump",
    "*.rpt.txt": "access-dump"
  }
}

Useful Links

These links may be interesting to further improve the development.

• Rubberduck
• vbWatchdog
• Export Access data to: MySQL, MSSQL, PostgreSQL [Bullzip]
• Using the ribbon menu in Access: General documentation, list of imageMSO pictures, imageMso gallery
• Allen Browne's tips for Microsoft Access
• Microsoft Access Developer and VBA Programming Help Center
• MDB Tools

Feedback

Share your feedback as a GitHub issue.