How copy the realtions to a new MDB?

[JeffSM]

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]

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.