Can't edit data in query

  • Thread starter Thread starter MIke Collard
  • Start date Start date
M

MIke Collard

MS Access help suggests it should be possible to edit data
in a one to one query but I get 'This recordset is not
updateable'. Any clues?

Thanks

Mike Collard
 
Try making sure that the fields you are using to connect
the tables in the query are primary keys. If both can not
be one is better than non. Next try to use outer joins
instead of a inner join. Usually if I do these few things
I can edit my query dynaset.

Hope this helps.

Jay
 
Back
Top