Kelly, Access will not allow you to alter the value of the primary key for redundant entry purposes. If you even go into access view and alter tables via the GUI, then you will immediately be errored saying cannot change the value of the pri key.
Bye Bye. - Pauly- ----- Original Message ----- From: "Kelly Zhu" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 10:22 AM Subject: update value for a primary key field > I have a db in Access. I cannot use ASP page to change the value of a field > assigned with primary key and has a one-to-many relationship with a field in > another table. But I have no problem doing the same thing in Access. The > ASP page doesn't give me error, but just doesn't do the job. > > Please help. Thanks. > > Kelly > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > > > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
