Hi All,
I have a problem making changes to a query. The query is extracting
data from three different tables, but when I run the query in a form
or datasheet view I can't make any changes to the data. I can view the
data but not make changes.

Can anyone help? I would like to make changes to the data.

Thanks

John

You appear to have created an unupdateable query. If the Help is not
sufficient explanation, Google the archives at http://groups.google.com.
Updateable and unupdateable queries have been discussed at length.

If the joins are not "ambiguous" to the software, and if you have included
the unique identifier(s) of each record you want to update, you will have
made a good start. Note that a corresponding field from one of the other
tables is _not_ "just as good".

Larry Linson
Microsoft Access MVP

"John" <jnnybgud2000@yahoo.com> wrote in message
news:b5fa58b4.0406201815.31786d0c@posting.google.c om...[color=blue]
> Hi All,
> I have a problem making changes to a query. The query is extracting
> data from three different tables, but when I run the query in a form
> or datasheet view I can't make any changes to the data. I can view the
> data but not make changes.
>
> Can anyone help? I would like to make changes to the data.
>
> Thanks
>
> John[/color]

John,
If you have any grouping or various other features in your query, the
recordset becomes non-editable.
If not, post your SQL and we can look at it for you.
Cheers,
Doug

--
Remove the blots from my address to reply
"John" <jnnybgud2000@yahoo.com> wrote in message
news:b5fa58b4.0406201815.31786d0c@posting.google.c om...[color=blue]
> Hi All,
> I have a problem making changes to a query. The query is extracting
> data from three different tables, but when I run the query in a form
> or datasheet view I can't make any changes to the data. I can view the
> data but not make changes.
>
> Can anyone help? I would like to make changes to the data.
>
> Thanks
>
> John[/color]

jnnybgud2000@yahoo.com (John) wrote in message news:<b5fa58b4.0406201815.31786d0c@posting.google. com>...[color=blue]
> Hi All,
> I have a problem making changes to a query. The query is extracting
> data from three different tables, but when I run the query in a form
> or datasheet view I can't make any changes to the data. I can view the
> data but not make changes.
>
> Can anyone help? I would like to make changes to the data.
>
> Thanks
>
> John[/color]

One method to solve this problem is to join the tables only on Primary
Keys, if possible. When that happens, Access often seems to be able
to size up the situation and allow edits. If that doesn't solve it
try using some 'IN' SQL constructions in criteria fields instead of
the joins. Also, post the query SQL string you are using. You are
likely to get some specific useful recommendations from this NG that
way.

James A. Fortune

Hi All,
Thanks for your comments. I believe I have solved this issue by
selecting query properties, changing Recordset Type from Dynaset to
Dynaset (Inconsistent Updates). It seems to be working.

Are there any problems to use the query with Dynaset (Inconsistent
Updates)?

Regards

John

jafortun@oakland.edu (James Fortune) wrote in message news:<a6ed3ce7.0406202141.5721fccb@posting.google. com>...[color=blue]
> jnnybgud2000@yahoo.com (John) wrote in message news:<b5fa58b4.0406201815.31786d0c@posting.google. com>...[color=green]
> > Hi All,
> > I have a problem making changes to a query. The query is extracting
> > data from three different tables, but when I run the query in a form
> > or datasheet view I can't make any changes to the data. I can view the
> > data but not make changes.
> >
> > Can anyone help? I would like to make changes to the data.
> >
> > Thanks
> >
> > John[/color]
>
> One method to solve this problem is to join the tables only on Primary
> Keys, if possible. When that happens, Access often seems to be able
> to size up the situation and allow edits. If that doesn't solve it
> try using some 'IN' SQL constructions in criteria fields instead of
> the joins. Also, post the query SQL string you are using. You are
> likely to get some specific useful recommendations from this NG that
> way.
>
> James A. Fortune[/color]