Tables & Queries

J

jyotisb

Hi,

I am working on a ACCESS database(created by another programmer) which
had 3 tables. There were couple of queries generated using either 2 of
the 3 tables or all 3 tables. There is another query also, which is
based on the first 2 queries. Now If I create forms based on this
query,
1. I am not able to add/edit the data.
2. The tables are generated by importing the dbf files everyday
midnight.

I am confused..Do I need to merge all the data in one table and create
queries or Is there a better way to handle this problem?

Thanks.

J
 
M

Micah Chaney

If you have a "Join Query" (Query based off two or more sources) the
recordset is not updateable. What are you trying to do? Perhaps we can help
you with a more efficient method of getting the results you want and still
allow you to modify the data.
 
Top