Recordset not updatable

[sjdk]

I am working with an access front end and a SQL backend. I have the following query, and I can't for the life of me figure out why it isn't updatable. The fields called 'KeyField' and the key fields.

SELECT tblTimeCard.*, tblTimeCardDefaults.KeyField, tblTimeCardDefaults.NightShift, tblTimeCard.NightApprove
FROM tblTimeCard INNER JOIN tblTimeCardDefaults ON tblTimeCard.SocialSecurity = tblTimeCardDefaults.SocialSecurity
WHERE (((tblTimeCardDefaults.NightShift)=1) AND ((tblTimeCard.NightApprove)=0));

As always...thanks in advance....

Steph

 

[PHV]

What is the PrimaryKey of tblTimeCardDefaults ?
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sjdk]

The primary key on each table is 'KeyField'.

Thanks!

 

[PHV]

Have you sufficient rights on the SQL side ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sjdk]

Yes, I do.

This is driving me crazy...I've done 100 of these simple queries, and they work just fine. I have made sure that I have a primary key on each table, put the primary key in the query, there are no calculations, nothing out of the ordinary...and it still isn't updatable?!?!

 

[PHV]

Are each table updatable ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sjdk]

Yes, they are.

 

[fneily]

tblTimeCard.SocialSecurity = tblTimeCardDefaults.SocialSecurity

should be changed to
tblTimeCard.Keyfield = tblTimeCardDefaults.Keyfield
to create an updatable recordset.

Your relationship is based on Keyfield not SSN.

By the way, I used to work for the Social Security Administration and it's illegal for anyone except the Federal govt. to use SSN in tracking employees. But, as you know, everyone does it. So much for laws.