Editing Data in a Query Containing 2 Tables

  • Thread starter Thread starter Helen
  • Start date Start date
H

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.
 
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.
Click to expand...

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.
 
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.
 
Back
Top