Not sure where to start - Editing Access database linked to model

Need some direction here...

I inherited a Microstation 2D model at work. It is littered with pipelines (in the form of lines), all on the appropriate levels (gas, oil, sewer, drain, etc).

There is some intelligence to the lines, with the use of an .mdb Access database.

Once I connect to the .mdb, (and using Review Database Attributes) I click on the line and it tells me what project the pipeline is associated with.

However, most of the lines have no such intelligence. That's fine.

The issue is no one (and I mean NO ONE) here knows how to add intelligence to those lines by editing the database.

I can draw the line on the correct level, but I don't know how to associate the line to the database, to add the project #, line service, line size, etc.

I honestly don't even know where the database is or how to find it.

Can anyone help me get started? How do I locate the database? How do I associate new lines I draw to the database?

Thanks.

Edit: I'm using Microstation Connect Update 14, Ver. 10.314.02.01

Parents
  • if  most have no intel or  meta data then it would probably  be a lot easier to create and use item types and  forget data bases all together ... this would mean having to add intel to the lines  manually thro items but it depends  how many  lines , are they continuous or segmented  and  how to copy the already used  data base info and add it to the items  before you remove the data base.. Items will let you do reports and  basic sql .. this data base approach was old school  method before we  had real GIS programs... some places have persisted with the database method in order to import it all in gis programs and  do away with the data base.. once in gis its easy to keep updating  and even import lines from cad and add the intel in gis later....

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

  • Thank you so much. I think this might be the best way to move forward with this.

    I played around with Item Types and it seems straight forward and easy to attach properties to lines. There are hundreds of line segments, and maybe 50 categories and a few subcategories those lines belong to.

    I'm not yet sure what the differences are between Item Type Library, Item Type, and Property Type, and the settings within, but I'll give it a try.

    If I reference in the dgn that has the item types, am I still able to see those Item Types in Properties? We reference the dgn with the database for our drawings, and can Connect to the database in the new drawing just fine.

Reply
  • Thank you so much. I think this might be the best way to move forward with this.

    I played around with Item Types and it seems straight forward and easy to attach properties to lines. There are hundreds of line segments, and maybe 50 categories and a few subcategories those lines belong to.

    I'm not yet sure what the differences are between Item Type Library, Item Type, and Property Type, and the settings within, but I'll give it a try.

    If I reference in the dgn that has the item types, am I still able to see those Item Types in Properties? We reference the dgn with the database for our drawings, and can Connect to the database in the new drawing just fine.

Children
No Data