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

[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

 

[Steve Schapel]

Martin,

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