downloading the Database...

I was wondering what people do when they need to download the database from an ASP website...

I use ASP with an Access 2000 database. When I need to download the DB to modify it, current users to the site get errors... obviously because the DB cannot be access while I am donloading it.

What do others do in this situation?
I was thinking of putting a temporary page up, but if they have bookmarked a particular page, that would bypass the temp page....

is there any script or any way of stopping ANY page requests while I download the DB??

Cheers.

I suggest setting up a few pages in your admin that can allow you to modify the DB online, this is the way it is typically done.

Cheers,
Vantera

or download the database during your offpeak time. to save the less convience

i didnt realise you could manipulate the DB whilst it is online?? ie from an admin area?

I am using an Access2000 database (.mdb)
---
how can I add a field to a table without having to download it then?! This would be so much easier!!

I have also worked out the "off peak" time for the website... so if need be, I'll download it then...trouble is, I have to stay up most of the night!!!

Ahh you want to modify tables and stuff not just data? Well in that case you're better off downloading it to modify it, or you can look up the SQL code to do it (which you use like any other SQL code in ASP). Check out www.ASPIN.com if you want more info, it should have it.

Cheers,
Vantera

Hi fakker,

We seem to be chasing similar objectives.

Next task I will tackle is to use a Data Form Wizard to create a form which will read and / or amend the database.
Any comments about VB6 in 24 Hours, Hour 15, p263-264 ?
But, is it true that the Data Form Wizard is only available in the full version of VB 6.0, and that it is not included in VB 6.0 trial versions?

Regards
Derek