If you have already edited the data in the new database, it will probably be
easiet to recreate the relations by hand, dealing with any relational
integrity problems that have arisen by editing the data without
relationships in place.
If you have not modifed the data, only the queries, forms, reports, and
code, then you could create a new A2000 mdb, import the tables with
relations from A97, and then import the other objects from the A2000 copy.
If you are good with VBA code, it is possible (but probably not worth it) to
OpenDatabase on the A97 database, loop through the Relations collection, and
for each relation examine its Properties and Attributes and loop through
its Fields collection, so that you can CreateRelation(), set the properties
and attributes, CreateField() and Append to the Fields collection, and then
append the new relation to the Relations collection of the target database.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"fastfish" <fa******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
I have converted a db from access 97 to 2000 - some how the
relationships didn't get moved over. Big problem.
Is thier any way, other than recreating it by hand, to duplicate the
relationships from the old version to the new version?
