Printable View
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
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.