Re: Flushing data

I don't know what you mean by "making verification"
I have used the command, and it has fixed problems where caching was the
issue.
Isn't there some way to force a physical write like
CurrentProject.Connection.ForceWrite or FlushBuffers or the like.
Thanks for your help

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:Oc$3px3PFHA.2384@xxxxxxxxxxxxxxxxxxxxxxx
> I don't know, I never used this particular command. Did you make the
> verification first?
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
>
>
> "Walter Levine" <wlevine@xxxxxxxxxx> wrote in message
> news:OJKQnv3PFHA.904@xxxxxxxxxxxxxxxxxxxxxxx
> > Thanks for the reply
> > would this code help?
> > Response.Cache.SetCacheability(HttpCacheability.NoCache);
> >
> > "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> > wrote in message news:eBchQi3PFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
> >> 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
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>


.