I am only in the last phases learning of the potential problems in Locking. it seems that Row level locking must be implemented using my own fields as SQL will...

there will be three distinct roles for users in the Database.

1. Demographics personel who NEVER may see Medical data ( Mandated standard for medical applications )

2. the Nurse role who...

Well based on your posting of last night I looked at that portion of the problem and you are right. One of the best parts about the SQL feature set...

Hmmmm,

in order for the experts to help me I need to better define the problem ( meaning my deficit of knowledge ) . I come from a...

Yes, Sql 2000 will be a part of our Setup to the customer. Predeployed on a platform and ready to plug and integrate to existing network. For a Doctors office...

I left out one small detail in my last post.

one of our primary objectives is for the physician to have the ability to have our setup in his office if...

Well with that said I suppose that in order for you to give me the best advice you will need to know a few details of the objective i am...

Many thanks for the quick response. Like I said I am very much a Newbie in VB, I have lots of Good friends on the web who...