I cannot add new record to select query

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

How do I troubleshoot a 2 table query that will not allow new records to be
added? Both tables allow new records. But the tables combined will not.
 
hi Denise,
How do I troubleshoot a 2 table query that will not allow new records to be
added? Both tables allow new records. But the tables combined will not.
Click to expand...
A SELECT query must be key-preserving for Access/Jet to append new
records. This means:

a) Each table used to built the query must have a primary key.
Try adding the primary key fields from each table to your query.

b) The SELECT query must not be "complex". Some query operations
(grouping, joins, sub-selects) may lead to a query which is not updatable.

If a) don't work, you may post your select SQL statement.


mfG
--> stefan <--
 
Denise said:
How do I troubleshoot a 2 table query that will not allow new records to
be
added? Both tables allow new records. But the tables combined will not.
Click to expand...

The query is not updatable. Might be a join problem, more info needed.

Keith.
www.keithwilby.co.uk
 
Back
Top