Frans_Truyens
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
I don't believe SQL Server diagrams are something Access can link to, so the answer is likely 'You can't do that'.
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/question s/11719092 /read-data -from-a-sq l-server-d atabase-in -visual-ba sic-in-ms- access
Jim Horn's comment is the only possible solution.
#a42069919
I think the question probably deserves oblivion, since it is abandoned.
#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 TRIALMembers 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.