Create a Database Model Diagram

[Joshann]

I would like to create a database model diagram from an existing Access database. Several years ago, I did this using Microsoft Visio, and Visio automatically created it. Now, I can't get that to work. The versions I have are Access for Microsoft 365 and Visio Plan 2. Does anyone know how to automatically create a database model in Visio for an existing Access database? Or does anyone know of another software that I could use to automatically create a database model? Note that I know I could use an Access' Relationship Report, but it isn't detailed enough.

Thank you!

 

[theDBguy]

Hi. Not sure if any of these can do what you want, but here are some other potential options besides Visio.

Analyzer By Crystal

Total Access Analyzer Comparison to Microsoft Access Database Documenter

Total Access Analyzer: Comparison to the Built-in Microsoft Access Database Documenter

www.fmsinc.com

 

[AccessBlaster]

If you have SSMS you can make diagrams. This is a free program with very powerful tools.

 

[Joshann]

Have the relationships been created?
Are you working in the BE? This is where relationships exist. Not in the FE.

i am working in the BE.

 

[Joshann]

If you have SSMS you can make diagrams. This is a free program with very powerful tools.

View attachment 92754

Thank you! I don't know what SSMS is, so apparently I don't have it.

 

[Joshann]

Hi. Not sure if any of these can do what you want, but here are some other potential options besides Visio.

Analyzer By Crystal

Total Access Analyzer Comparison to Microsoft Access Database Documenter

Total Access Analyzer: Comparison to the Built-in Microsoft Access Database Documenter

www.fmsinc.com

Thank you!