Linked tables in a Query Problem

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

This is vague, but hopefully, it is an easy problem to
answer.

I keep having a problem when I add a second table to a
query. The second table has a field that I link to the
main table. However, when I do this, I find that it
doesn't let me add records to the main table. If I delete
the link, then I can add records, but get a Cartesian
result in my query.

Any ideas?

Ken
 
When you make the join, you're making the query nonupdatable. The reasons
for why a query may be nonupdateable are varied and sometimes not obvious.
See these links for more info (watch for word- and
line-wrapping; all URLs are one line):

"When can I update data from a query?"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
l/acconDeterminingWhenCanUpdateDataQueryS.asp


"Harnessing the Power of Updatable Queries"
http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/
html/msdn_harness.asp


If you can post the SQL of the query that is nonupdatable, we might see what
the problem is.
 
Ken,

Thanks for the links. I read further. I don't have a
specific example, but it happens quite often. I need to
review relational database basics and set everything up
right. Many times I have a separate table that is used by
a combo box, where I ran the Combo Box wizard and I still
get the cannot update recordset error message. I don't
know VBA yet or SQL.


Thanks again!

Ken L.
-----Original Message-----
When you make the join, you're making the query nonupdatable. The reasons
for why a query may be nonupdateable are varied and sometimes not obvious.
See these links for more info (watch for word- and
line-wrapping; all URLs are one line):

"When can I update data from a query?"
http://msdn.microsoft.com/library/default.asp? url=/library/en-us/off2000/htm
l/acconDeterminingWhenCanUpdateDataQueryS.asp


"Harnessing the Power of Updatable Queries"
http://msdn.microsoft.com/library/default.asp? url=/archive/en-us/dnaraccgen/
html/msdn_harness.asp


If you can post the SQL of the query that is
Click to expand...
nonupdatable, we might see what
 
Back
Top