Many thanks Gail,

I am not planning to display the RV binary number, but I need to know what it was when I read the record or records. How will the...

Regarding Username=sa and Password = saPass, I can safely say "i am not doing that":-)

Regarding ROWVERSION, I need this value if I want to check whether the specific row was...

I have been trying to use ROWVERSION. I created a simple table as can be seen in attachment Gail1.jpg.

I use the following ADO code in the open event of the...

Gail thanks for the succinct analysis.

It is also nice to have someone in the same timezone!!

It appears that the "rowversion" data type would do the trick. It also appears that...

Thanks Gail & Craig for your input,

Would use of the TIMESTAMP data type be of any help? As I understand it, it is used for version-stamping table rows. I have...

After some more read maybe this would lock a record (and only one record) until all work is done,

BEGIN TRAN

SELECT * FROM tblName WITH (HOLDLOCK, ROWLOCK)

WHERE ID = someID

/* While...

Many thanks for your replies. I did some research and found out the following:

Scott regarding "sp_getapplock", it appears that from what I read, it should not be the first choice,...

Gail, have taken your advice seriously. I will see whether the functionality can be modified to avoid the headaches.

Thanks,

John

Many thanks for your input to both of you.

I have developed a Dental Practice Management Software package (www.VisualDentist.com) using Access and Jet. While this setup is adequate for a small...

Many thanks for your reply Gail,

I appreciate the fact that it would be easy to mess up. If a user needs to work on a specific record for a few...

Thanks for your reply and suggestion article. I am doing some reading in the mean time.

One of the problems which I am trying to solve is once a user accesses...

Many thanks for the reply.

I need to use Access (not .NET) as the front end and had a general question about ADO and Native Client. As time goes by, I...