Thanks for the ideas... [Smile]

However, Whenever I run the DBExecuteSQL the error code is always -2147352567.

These are the lines of sql I tried...

DBExecuteSQL($objConn,'UPDATE Staff SET Staff.[3/4ID] = "ABC1234" WHERE Staff.[SocialSecurity#]="123-45-6789";')

DBExecuteSQL($objConn,'UPDATE 3/4ID="ABC1234" IN Staff WHERE SocialSecurity#="123-45-6789";')

DBExecuteSQL($objConn,'UPDATE Staff.[3/4ID]="ABC1234" IN Staff WHERE Staff.[SocialSecurity#]="123-45-6789";')

The first line of sql is straight from Access, and it works within Access, but not out.

Any more ideas? [Confused]