M
martinmike2
Is it possible to completly lock out a split DB for maintenance? I
have a relatively small DB, only 14mb that I will periodicaly need to
"take offline" to perform maintenance on. Is this possible?
What I am thinking of is that I would create a table called tblMaint
with one field in it. This field would store a 1 or a 0. 1 = offline
0 = online. The code would then check this field for the value and
prevent the db from fully opening.
The problem with this solution is that anybody that has the db open at
the time i take it offline would not be affected. Is there a better
way to accomplish this? Its slightly frustrating to have to call
everybody to see if they have it open or not and if they do to please
close it.
have a relatively small DB, only 14mb that I will periodicaly need to
"take offline" to perform maintenance on. Is this possible?
What I am thinking of is that I would create a table called tblMaint
with one field in it. This field would store a 1 or a 0. 1 = offline
0 = online. The code would then check this field for the value and
prevent the db from fully opening.
The problem with this solution is that anybody that has the db open at
the time i take it offline would not be affected. Is there a better
way to accomplish this? Its slightly frustrating to have to call
everybody to see if they have it open or not and if they do to please
close it.