July 7, 1999

Question: I created an ASP that uses VB script to access an Access 97 database in a test environment. Here is the query used: “select * FROM property WHERE user

In a high-volume application, there’s a good chance that two separate transactions will both run the SELECT statement and acquire read locks before either can acquire the write lock required