Link to home
Start Free TrialLog in
Avatar of Frans_Truyens
Frans_TruyensFlag for Belgium

asked on

Read MS SQL database diagram with VBA

With VBA, in MS Access 2013, I need to be able to read a MS SQL Server database diagram. I am working with a .accdb
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

I don't believe SQL Server diagrams are something Access can link to, so the answer is likely 'You can't do that'.
Avatar of Frans_Truyens

ASKER

Can't you do it through ADO? You open via ADO the MS SQL Server database, and query it? I don't know how to do it, that is the problem
I've never done that before, and I believe the database diagram is just an XML representation and not a queryable object.
If I may ask, why do you want to read it via VBA? You can read or print it directly from SQL Server.
May be this one help you but I m not sure: stackoverflow.com/questions/11719092/read-data-from-a-sql-server-database-in-visual-basic-in-ms-access
Jim Horn's comment is the only possible solution.
#a42069919

I think the question probably deserves oblivion, since it is abandoned.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.