Good day all,
OK here’s the question…
Q: Which is the best programatic method for placing a database into a read only mode, and then freeing it as a user logs in then out?
Our development team have a particular problem at the moment which requires some lateral thought to affect a solution. We are currently implementing the design for a n-Tier application, written in VB6 with the proprietry database first being realised in SQL Server 7 (Orcale and SQL Server 2000 solutions are being designed in parallel).
What we require is your opinions of the most effective way of allowing users to ‘Check-In’ and ‘Check-Out’ an entire database.
Some points to guide you:
1. There is more than one database
2. Each database is identical in structure
3. The FIRST user to login MUST get full Read/Write access
4. Other users will then only get Read access
All answers will of course be warmly received, and given full consideration.
Tank you.
George