|
 |
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.
|
|
 |