I have this query in Microsoft access 97 and it works fine, But I was trying to
make this a stored procedure, but I keep on getting errors, How could I redo
something like this?

UPDATE ACI_Randomization_Schedule
SET ACI_Randomization_Schedule.Pat_ID = dbo.Patient_Rand_NameTable.[PATIENT_ID],

     ACI_Randomization_Schedule.Pat_Name = [Patient_Rand_NameTable].[Name], 
     ACI_Randomization_Schedule.Pat_AMS_Schedule 
[Patient_Rand_NameTable].[PROGRAM], 
     ACI_Randomization_Schedule.Pat_TDays 
[Patient_Rand_NameTable].[Total_PU_Days], 
     ACI_Randomization_Schedule.Pat_Active = [Patient_Rand_NameTable].[Active], 
     ACI_Randomization_Schedule.Mon = [Patient_Rand_NameTable].[PU_Mon], 
     ACI_Randomization_Schedule.Tue = [Patient_Rand_NameTable].[PU_Tue], 
     ACI_Randomization_Schedule.Wed = [Patient_Rand_NameTable].[PU_Wed], 
     ACI_Randomization_Schedule.Thur = [Patient_Rand_NameTable].[PU_Thu], 
     ACI_Randomization_Schedule.Fri = [Patient_Rand_NameTable].[PU_Fri], 
     ACI_Randomization_Schedule.Sat = [Patient_Rand_NameTable].[PU_Sat], 
     ACI_Randomization_Schedule.Sun = [Patient_Rand_NameTable].[PU_Sun]



Thanks