Updating Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using sql 2000 and Access 2003. I have a adp database that contains about
200 clients. Part of the data is the client's doctor, nurse and other staff.

I'm trying to figure out a way to develop something so someone other then me
can update the information. I'm need a way to update lets say if Dr. Smith
leaves and Dr. Jones takes his place and 75 clients.

With an mdb could create an update query with parameters but I'm not sure
how to do this with an adp.

Does anyone have any ideas on how to do this or better yet a good example.

Thanks for the help,


Paul
 
p> I'm trying to figure out a way to develop something so someone other
p> then me can update the information. I'm need a way to update lets say if
p> Dr. Smith leaves and Dr. Jones takes his place and 75 clients.

You can run an update query by creating a stored procedure in Access.

But rather than updating clients to the doctor, I would create some "virtual
doctor" and then changed his name - I think this would be the closest
reflection of the reality. I.e. there would be one table for doctor
positions, with the linked clients, and another table for the doctor
individuals. Each active individual would hold a position. When the
individual is replaced, you link another individual to the position.

Vadim Rapp
 
Do you know where I can get an example of a stored procedure that will update
information?

Thanks,

Paul
 
Back
Top