Editing Data in a Query Containing 2 Tables

[Helen]

I have converted an Access97 database to Access2002.
There is a query that contains 2 tables that are joined
by 1 field. Running the query in 97 produces a dataset
which is updateable, however running it in 2002 produces
an unupdateable dataset. Even creating a new query with
2 tables produces an unupdateable dataset. How do I get
my query updateable again?

Many thanks for any help.

 

[John Vinson]

I have converted an Access97 database to Access2002.
There is a query that contains 2 tables that are joined
by 1 field. Running the query in 97 produces a dataset
which is updateable, however running it in 2002 produces
an unupdateable dataset. Even creating a new query with
2 tables produces an unupdateable dataset. How do I get
my query updateable again?

Many thanks for any help.

A200x is in fact more stringent than A97 about updatability. Do you
have a unique Index (such as a Primary Key) on the "one" table joining
key? Is there a relationship defined?

If both are true (or if changing the tables so they are doesn't help)
please post the SQL of the query.

 

[Helen]

Many thanks for your help. This did indeed work, but I
have now got to another problem! I'll investigate
further myself before posting anything else.

Regards,

Helen.