Hi all,
I am working on a website that lets users change the contents of a 
database. 
Is there a way to allow users to view the effects of their changes through 
my webpage? For example, instead of manually generating a report and 
uploading it to the internet every 10 minutes, is there a way to 
dynamically update my report using ASP?

If you have any suggestions please email me at hakoch2@h...

Thanks in advance. 

~Jon HAn

I currently have a database on line behind a web page and
have a couple of comments.  If I am understanding you allow
the users to change the webpage on line in real time.

I have found when I make changes to a database myself and
if I have my web page looking at it, in the sense the 'asp'
page that displays specific things.  When the database is
changed and when the web page is refreshed I see the new
data.

This seems to be automatic when the asp page runs as it has
specific things it looks for and gets a fresh copy of what
is stored each time it runs.  While I am not linked directly
to page to enable changes and re-read directly, I suspect
the refresh might do it.  I use Access and it is not designed
for true multiple users so I have seperated the data base update
to the display because of this limitation.

I am not sure if this helps or not but it was a shot.  Depending
on what your specific things you need done, Access may not be
an optimum solution.


>From: "jon hahn" <hakoch2@h...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] **Dynamic updating of an Access report through ASP
>Date: Wed, 17 Apr 2002 19:20:04
>
>Hi all,
>I am working on a website that lets users change the contents of a
>database.
>Is there a way to allow users to view the effects of their changes through
>my webpage? For example, instead of manually generating a report and
>uploading it to the internet every 10 minutes, is there a way to
>dynamically update my report using ASP?
>
>If you have any suggestions please email me at hakoch2@h...
>
>Thanks in advance.
>
>~Jon HAn




"Racial interaction is described by Physics,
for every action there is an opposite
reaction.  We hate them, they hate us, and
we hate them back. And there you are, we are
trapped by mathematics."
    -Londo B5

http://aa8vs.dhs.org:81/aa8vs


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Jon,

I'm not clear about your question, so you may be asking for more than I 
think.  In Beginning ASP 3.0 from Wrox, they use a method in which the 
user updates the database and, in the same program, the recordset is 
closed, reopened, a SQL command is executed to find the updated record and 
it displays the new record.  The code can be found in the book, but I 
believe its readily available from other sources.

I also agree with the first reply that refresh may be all that's 
necessary.  I've found with PWS you need to refresh but with later servers 
it's not necessary.

Hope this helps.

Steve Proctor

> Hi all,
I>  am working on a website that lets users change the contents of a 
d> atabase. 
I> s there a way to allow users to view the effects of their changes 
through 
m> y webpage? For example, instead of manually generating a report and 
u> ploading it to the internet every 10 minutes, is there a way to 
d> ynamically update my report using ASP?

> If you have any suggestions please email me at hakoch2@h...

> Thanks in advance. 

> ~Jon HAn

Thanks for your help.
what I'm asking for may not be possible. I am able to update the data 
tables and such, but the problem is that I want my REPORT SNAPSHOT to be 
updated. As a temporary solution i have a macro that runs itself and 
generates a new snapshot periodically.

Again, thanks for your help.

> Hi all,
I>  am working on a website that lets users change the contents of a 
d> atabase. 
I> s there a way to allow users to view the effects of their changes 
through 
m> y webpage? For example, instead of manually generating a report and 
u> ploading it to the internet every 10 minutes, is there a way to 
d> ynamically update my report using ASP?

> If you have any suggestions please email me at hakoch2@h...

> Thanks in advance. 

> ~Jon HAn