DbSchema for Microsoft Access Databases

DbSchema is a powerful database management and design tool for Microsoft Access. It offers features such as visual schema design, team collaboration with GIT, schema deployment and HTML schema documentation.

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
  3. 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.
Connect Access MS in DbSchema

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.
Visual Features for Access MS in DbSchema

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.

Remember to enable Windows Firewalls Firewalls & anti-viruses may block database connections.