AC97 to 2k: DAO problem

[Bob C]

I have an Access application converted from 97 to 2002.
It was split so it has an Access97 database back-end (some
users still have Access97 and their app runs fine). The
problem is when adding records to tables TableA and TableB
(which have referential integrity - foreign key
relationship), I get a 3201 DAO.Recordset error "You
cannot add or change a record because a related record is
required in table 'TableA'"

I have (a) upgraded the db to 2002, and removed all table
relationships (!) and still the problem persists. I'm
quite certain the error is coming from DAO, and it's
because DAO believes there's still a foreign key
dependency... but why? I have refreshed table links.

Any ideas?

Thanks for your help, in advance.

 

[david epsom dot com dot au]

I have (a) upgraded the db to 2002, and removed all table

relationships (!) and still the problem persists. I'm

The table relationships only exist in the BE database,
which is still A97. Is that the one you changed?

to see if there are any relationships left in a database,
open the VBA immediate window and paste this in:

for i = 1 to 1000 :?codedb.Relations(i).name: next i

the press the enter key. if there are any relationships,
they will be printed below the line. (it ends with an
error message!).

(david)