Webmaster Forum / ASP / Database Access / June 2009

I am building an application using classic ASP that may be used by
multiple users at a time.  What are the methods for working this out?
For example, if User A opens the application and selects a record,
they can be working on the record as it existed when they opened it.

I know this is really awkward but for the last three days now at around 5:30
PM our two (NLB clustered) webservers have been unable to connect to our SQL
2005 SP2 server.  The SQL server installation is configured in a failover
cluster.  The webservers are running Windows 2003 ...

I'm coming from an Access background but do not know how do this is in an
SQL DB.
The SQL has an ID (Identity) but would also like to have another unique
column emailaddress what should this be.