Re: Flushing data

Print somewhere the time on the ASP.NET page to make sure that you don't
have simply a problem of cached pages on the web server.

S. L.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC


"rhinoman" <wlevine@xxxxxxxxxx> wrote in message
news:u1%23xew1PFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
>I have an SQL database which was just upsized from Access
> The users access the database in two ways
> First, there is an adp project with forms, reports and modules which was
> also converted from the old mdb file. Users use the to make changes to
> the
> db using this program
>
> second, I wrote an ASP.NET app in C# to allow (read-only) viewing of the
> database information from the Internet or Intranet. Many users access
> this
> program for looking at the data.
>
> The problem is that updates done to the database in the adp application do
> not seem to be available to the Web users until either some time has
> passed,
> or the adp app has been shut down. In otherwords, it seems that updates
> are
> not being physically written to the database immediately. This is
> undoubtedly a reasonable thing in an industrial strength database.
>
> My question is, can I force a physical write to the database from within
> VBA?
> Maybe if I could use a transaction, the Commit would write out the data,
> but
> i cannot get Transaction to work in VBA, are they supported??
> Thanks for any help
> Walter
>
>
>


.

Relevant Pages

  • Re: Opening dbase in full screen with no way to "back end"
    ... I have a database that I want to open viewing a form (the ... "switchboard") full screen, without allowing users access to editing ...
    (microsoft.public.access.security)
  • Re: Flushing data
    ... > have simply a problem of cached pages on the web server. ... >>I have an SQL database which was just upsized from Access ... >> The users access the database in two ways ... >> First, there is an adp project with forms, reports and modules which was ...
    (microsoft.public.access.adp.sqlserver)
  • Flushing data
    ... I have an SQL database which was just upsized from Access ... The users access the database in two ways ... The problem is that updates done to the database in the adp application do ... i cannot get Transaction to work in VBA, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Do web services make sense for me?
    ... Web Service is one of the way involve your class. ... > As far as I can tell, I will still need to give the users access to my ... > database, because I have to have the ... > Ron L ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Do web services make sense for me?
    ... Web Service is one of the way involve your class. ... > As far as I can tell, I will still need to give the users access to my ... > database, because I have to have the ... > Ron L ...
    (microsoft.public.dotnet.languages.vb)
Loading