May not be true. I am able to change the value of field assigned with the primary key, and Access will do cascade update in the related table. I am using office xp. But it seems you cannot achieve the same via ASP. Thanks. Kelly
> 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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
