Recordset is not updatable - simple inner join query - why not?

  • Thread starter Thread starter Martin Lacoste
  • Start date Start date
M

Martin Lacoste

I've scoured the help, the net, newsgroups... and still can't figure
out why a simple query I've set up is not updatable. All permissions
are on, locks are not enabled, unique values is no, primary keys are
in both tables, etc.. Any ideas? Should this not be updatable?

Here's the SQL:

SELECT tblCantus.Key, Master.Key, tblCantus.FeastName, Master.ID,
tblCantus.ID
FROM tblCantus INNER JOIN Master ON tblCantus.ID = Master.ID;

Any help is greatly appreciated - I feel like offering a prize of some
sort - how's my eternal respect and gratitude...? ;-)

Thanks!
Martin Lacoste
 
Martin,

Here's my guess... tblCantus.ID and Master.ID are both Autonumber data type?
 
Back
Top