Bullschmidt.com
Home
Web Database Concept
How We Work Together
Bio
Web Database Sample
Classic ASP Design Tips
Bar Chart Tool
Web Design Resources
Access Database Sample
Classic ASP Design Tips
Lock Out Users While Uploading and Downloading the Database
These are opinions of J. Paul Schmidt, MBA.
No warranties are either expressed or implied.
To Use Paul's Services:
Paul@Bullschmidt.com
It is often convenient to have a way to lock out users from data-related pages when doing maintenance such as FTP'ing the database.
To do this you could temporarily "turn off" the database-related Web pages by having an included file perhaps called config.asp that has a variable perhaps called mbolSiteIsUp which is usually set to be True:
mbolSiteIsUp = True
But manually set this mbolSiteIsUp variable in the included file config.asp to be False when you do maintenance such as downloading or uploading the database:
mbolSiteIsUp = False
And on each page have code that if mbolSiteIsUp is False then it redirects to a page that explains that this part of the site is temporarily down for maintenance:
' If site down for maint.
If mbolSiteIsUp = False Then
Response.Redirect "downformaint.asp"
End If
Or a cruder method (that would generate an ASP error for the user) would be to slightly rename the database while doing uploading and downloading.
And another way of downloading database information (in this case through HTTP instead of FTP) would be to provide a way for the user (and perhaps this would only be set to work for Admin level users) to download a CSV file of selected records.
To Use Paul's Services:
Paul@Bullschmidt.com
Copyright © 2000-2012
J. Paul Schmidt, MBA
Freelance Web and Database Developer
All Rights Reserved
Privacy Policy
