VBA Doorway to Database Properties


V

victorcamp

How do I access the data in the Database Properties window from VBA?

I have searched the help files and numerous properties via the Immediate
Window, but cannot find an opening to the underlying Database Properties in
the object model. I can access the ShapeSheet, but that has no info on the
relationship itself. I can get the field list via .Text in the individual
Entities, but not the table name. Where is all that stuff found? (I suspect
it might be through the UI, but I've had no luck there, either.)

My diagram is a reverse-engineered Access 2003 database, with over 280
relationships. The Page is huge and complex. When I refresh the model, I
lose all the text on the relationship lines. I want to be save all that
data, and re-create it, as well as new ones, via VBA. Some specific syntax
examples would be very, very helpful.

I'll be posting this in some other Newsgroups as well, though this is
obviously the most pertinent.
 
Ad

Advertisements

V

victorcamp

Success! Well, sort of. See this thread in microsoft.public.visio
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top