By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,566 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,566 IT Pros & Developers. It's quick & easy.

HELP 97 -> 2K and lost all relationships

P: n/a
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?

-chris

Dec 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?

Dec 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.