I think I have it now. I replaced the "set" with commas and my syntax is successful now.

I will post back if I still can't get it to work.

Thanks!!!

SMK

Steve:

From your example, I got this far:

CREATE PROCEDURE dbo.procApptOVDetailUpdate (@nApptID int, @ApReason int, @Radiol int, @mammTime int, @cxrTime int)

AS

Update ovd

    set ovd.ApptReasonCode = @ApReason

    set ovd.RadiolInfoCode=@Radiol

    set

Thought others might benefit from Mary Chipman's comments (from newsgroup):

An mdb is a better choice since you also have the flexibility of

storing static data locally in Jet tables, allowing you...