what determines if you can add a record to a query?

  • Thread starter Thread starter MattE
  • Start date Start date
M

MattE

I have two queries, each based on a simple single table (a different
table for each query). One allows me to add a record and the other
does not (either programmatically or via the Access UI).

Can anybody point me to how I can tell why? Thanks!
 
MattE said:
I have two queries, each based on a simple single table (a different
table for each query). One allows me to add a record and the other
does not (either programmatically or via the Access UI).

Can anybody point me to how I can tell why? Thanks!
Click to expand...

There is a help topic named "When can I update data in a query?"
 
Ah, I thought I'd seen that before, thanks! Turns out "Group By" had
snuck in there, removing that fixed it.
Matt
 
You must log in or register to reply here.

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

Combine Duplicates in Query 0
You can not add or change a record because a related record... 8
Query returning many duplicate records 6
Add new records in a query? 10
Append Query Issue 0
Add records via query in a one-to-may relationship 2
Parameter Query Won't Run 0
Access 2010 append query to SQL is very slow 0

Back
Top