update query problem, please help

  • Thread starter Thread starter tang.yifan
  • Start date Start date
T

tang.yifan

The scenario:

Form D is based on query C. then Query C is based on 2 tables: A and
B.

What I did:

I splited table A to 2 independant tables, A1 and A2. And I updated
query C to retrive from A1 and A2.

Problem:

Form D can not update query C anymore, hence can not update tables.

Thanks in advance!
 
I believe more info is needed. Here are some possibilities though.

If A1 and A2 do not have primary keys and you are trying to update them
through a query or form, you will not be able to.

If you are using outer joins in your query, often times you cannot
update your data.

Just out of curiousity, why did you split your table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required in Update query 2
Update query. Within the same table: populating field 2 from field 6
update query on a JOIN Table with a query Not Work 1
update query vs make query 5
select query access 2000 0
recursive relationship query question 8
Exicute an append query in an after update event 0
search query 0

Back
Top