Microsoft Access Database Management in VS Code

Connecting

To connect to Microsoft Access, follow these general steps:

1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
2. Add a New Connection: Click on the “Add Connection” icon.
3. Complete new connection form: Choose Microsoft Access as the type, and select the .accdb or .mdb file.
4. Connect: Click save to connect to your Access database.
5. Start Managing Your Databases: Once connected, you can start managing your tables and queries directly from Visual Studio Code.

For detailed instructions on connecting to Microsoft Access, refer to the Connect article.

Supported File Formats

• .accdb - Access 2007 and later (recommended)
• .mdb - Access 2000-2003 (legacy format)

Features

DBCode uses the UCanAccess JDBC driver to provide cross-platform Access database support. This means you can work with Access databases on macOS, Linux, and Windows without requiring Microsoft Access to be installed.

Supported Objects

• Tables - Full read/write support with data editing in the grid
• Queries - Access Queries are displayed (read-only creation/modification)
• Columns - Complete column metadata including data types and nullability
• Primary Keys - Detection and display of primary key constraints
• Indexes - View table indexes
• Foreign Keys - Foreign key relationship detection and display

Capabilities

• Browse and query tables and views
• Edit data directly in the grid
• Export data to CSV, JSON, Excel, and other formats
• View table relationships in the ERD (Entity Relationship Diagram)
• Execute SQL queries
• Read-only mode for safe browsing

More Information

By using Microsoft Access with DBCode, you can connect to your Access databases, query and manage your data, and visualize your results, all directly from Visual Studio Code.

For more information about Microsoft Access, check out Microsoft Access.