Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Updating Databases


Message #1 by "Cam T" <camtlist1@m...> on Wed, 22 May 2002 16:08:12
I have a database using an (MS ODBC) DSN connection and I want to update 
it while in use, is this possible?

ie: I normally download the database and then re-upload the new version, 
but that won't work for a database that is constantly updated by 
users....plus that would probably make the database unavailable during 
the upload.

How can I connect to the database LIVE where ASP websites can still 
access the database and make updates?  ie: can I do this through MS 
Access or antyhing?

thanks,
Cam.
Message #2 by Greg Griffiths <greg.griffiths@g...> on Wed, 22 May 2002 18:07:24 +0100
just create an ASP page that connects to the DB and then runs the query, or 
you could build an Admin section to manage this.

At 16:08 22/05/02 +0000, you wrote:
>I have a database using an (MS ODBC) DSN connection and I want to update
>it while in use, is this possible?
>
>ie: I normally download the database and then re-upload the new version,
>but that won't work for a database that is constantly updated by
>users....plus that would probably make the database unavailable during
>the upload.
>
>How can I connect to the database LIVE where ASP websites can still
>access the database and make updates?  ie: can I do this through MS
>Access or antyhing?
>
>thanks,
>Cam.



  Return to Index