DbSchema Microsoft Access ER Diagram Designer

DbSchema is a Microsoft Access ER diagram database designer and query tool. Using DbSchema, you can design and document Microsoft Access databases while connected to the database server or without a connection.

Next, you can share the design with the team using Git. The design model loaded in DbSchema can be compared with the database, synchronization scripts can be generated, and the schema can be deployed to any database server.

Download DbSchema

How to Connect to Access Database

1. Access the Connection Dialog

   Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database and open the Connection Dialog.

   DbSchema automatically downloads the JDBC driver to connect to your database.

2. Configure the Connection

DbSchema makes it simple to connect to a Microsoft Access database. Follow these steps to establish a connection and explore your database visually.

• Open DbSchema.
• Click on Connect to Database and select Microsoft Access.
• Upload your .mdb or .accdb file.
• DbSchema will automatically detect the tables and relationships.

What You Can Do Next

• Explore and edit tables using the interactive diagram.
• Write and execute queries visually using the Query Builder.
• Generate test data for your tables.
• Export your database documentation as an interactive HTML5 page.
• Synchronize schema changes between different database versions.
• Share your database model with your team using Git integration.

Additional Resources

For more details, check out our official documentation.

Troubleshoot Firewall Issues

If you encounter connection issues, it may be due to firewall settings. Read how to enable Firewall Connections.