Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Visio Object Model from Access 2K (Ac 2K/Off 2K/Visio Std 2002)

    Top of the morning to you all - it's a beautiful day outside, but there's a storm brewing around my desk at the moment!

    I have a Data Dictionary (Access Mdb), that houses all information, about all systems, within my company - as a user tool, I would like users to be able to understand the data models in use in the various systems - the reason (before Charlotte asks), is that we have a large user community who write ad-hoc SQL in SAS, and as such, they need to understand the data and the data models.

    Because we are undergoing a major rebuild of our entire Core IT Platforms, the information in this database is constantly updated - as such, I can't draw data models in advance and bring them up as imagefiles.

    What I would like to do, is use user input to inform access which system, and which hierarchie(s) the user wants to see, and then allow that to be built in Visio, and then displayed in access.

    Has anybody done anything in this area?

    Does anybody know of a good book that is dedicated to the Visio Object Model and VBA?

    Many thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Using Visio Object Model from Access 2K (Ac 2K/Off 2K/Visio Std 2002)

    You might want to ask the question in the Visio board. If you want to create Visio models on the fly from your data dictionary, I have to say that I would expect the process to be *very* slow. Just putting the tables into Visio is one thing, but laying out the schema so that users can read it is a very time consuming process, even when done manually. I haven't seen any books on Visio specifically, but have you tried a Google search?
    Charlotte

  3. #3
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Visio Object Model from Access 2K (Ac 2K/Off 2K/Visio Std 2002)

    This post has been moved to the Visio Lounge all replies to <post#=254689>post 254689</post#> please.

    Kind regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •