query question

S

steve goodrich

If I create a select query using more than one table I can not edit the
records

I get a message on the status line " The record set is not updatable"

How do I setup the query so the records can be edited

Thanks

Steve
 
F

fredg

If I create a select query using more than one table I can not edit the
records

I get a message on the status line " The record set is not updatable"

How do I setup the query so the records can be edited

Thanks

Steve
Click to expand...

Some queries are not updateable.
See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated
 
E

Evi

It depends on what you have put into the query grid. Editable queries from
more than 1 table are the most common sort.

If, for instance, you have a Totals or a Crosstab query, then it can't be
edited.

Another typical scenario is when you have say a table of invoices with the
primary key of ItemID and a table of ItemsOnInvoices which has ItemID has
the Foreign key field.

You may try adding ItemID from the Invoices table (the 'one' table) whereas
you should have added ItemID from the ItemsOnInvoices table (the 'many'
table)

If your tables are not linked, then the query probably won't be editable.
For a list of what goes wrong, look on Allen Browne's pages.
http://allenbrowne.com/ser-61.html

The words in Bold Capitals refer to Sql words. To see these, open your query
in Design View. Click the down arrow next to the View button and choose SQL
View

If none of it makes sense. Past the Sql from your query in your next
message.

Evi
 
E

Evi

So what was the solution Steve? Someone else will be reading your thread,
even as we speak.

Evi
 
Top