How copy the realtions to a new MDB? [Archive]

Click to See Complete Forum and Search --> : How copy the realtions to a new MDB?

JeffSM

Oct 2nd, 1999, 02:58 AM

I need make a new file from an existing database (mdb), but some tables must come with their datas and others not. Using access I couldn't, it lost some relations.

Well, I need a code that copy the relations of a SourceMDBFile to a TargetMDBFile.

Can you give some help?

Jefferson

JHausmann

Oct 2nd, 1999, 03:43 AM

You can see the values but not manipulate them (you cannot cut-n-paste, for example), directly. The fields you're interested in are in MSysRelationships with szColumn/szObject being one side of the relationship, szReferencedColumn/szReferencedObject, the other. It should be possible to view the realtionships in the old table and apply them , manually, to the new.