Re: Flushing data

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


.

Relevant Pages

  • Re: ADP connection to SQL 2005 Standard SP2
    ... Create or choose a user database and you should be OK. ... Sylvain Lafontaine, ing. ... MVP - Technologies Virtual-PC ...
    (microsoft.public.access.adp.sqlserver)
  • 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: Trouble Opening Tables through ADP
    ... Does the account that you are using to connect to SQL-Server has ownership ... role for the database? ... Sylvain Lafontaine, ing. ...
    (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)