> > Before taking a few reports, we need to ensure that only one connection is > made to the database and all other computers need to close the connection to > that database. This is to prevent any additional entry(ies) that could be > made during the course of the report taking. This single-user mode is to be > there till the report is taken and few entries are passed. > > How to do it? Is it possible to switch to single-user mode from > application and back to multi-user mode once the work is completed? Or any > other solution available? > > Happiness Always > BKR Sivaprakash >
This concept is outdated. You should set your application to correct isolation level to get a consistent state.
