[AccessD] Relationships

[Jim Dettman]

<< Maybe some heavyweights like Jim Dettman (MVP) could put a bee(r) in the
bonnets of the Access Dev team toward fixing this serious inadequacy. This
is sooo frustrating!>>

I would not call myself a heavyweight, but certainly one of the voices in the choir on this.   In fact, I have already done so.   A list of features was requested, and this is one I asked for specifically (the ability to save multiple layout pages), but it was a bridge too far ☹.

They did however implement many of the suggestions that were made.   Those are covered in a video here:

https://www.youtube.com/watch?v=m4xTwmflTcI

 You might see some additional changes when the new Monaco SQL editor is released later this year, as the query designer pane and the relationships window share some common traits (same deal you got with the changes already done).

Jim.

-----Original Message-----
From: AccessD On Behalf Of Arthur Fuller
Sent: Saturday, February 12, 2022 3:49 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: [AccessD] Relationships

One of the most hateful things about Access is its implementation of the
Relationships diagram. Maybe theye team underestimated the ambitions of
Access developers, but when you get to 100 tables a single diagram is
ludicrous at best. By contrast, even the Community versions of SQL Server
allow creation of numerous diagrams, enabling you to focus on some small
group of trees, Rather than the whole jungle at once.
I have a client who doesn't wish to move to SQL Server. My only alternative
ithat I know of is to migrate the BE to SQL Server, create many
Relationship diagrams there, perform my adjustments there, and then
painstakingly copy them back to the ACCDB.
Maybe some heavyweights like Jim Dettman (MVP) could put a bee(r) in the
bonnets of the Access Dev team toward fixing this serious inadequacy. This
is sooo frustrating!

-- 
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com