Flushing data

  • Thread starter Thread starter rhinoman
  • Start date Start date
R

rhinoman

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
 
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.
 
Thanks for the reply
would this code help?
Response.Cache.SetCacheability(HttpCacheability.NoCache);
 
I don't know, I never used this particular command. Did you make the
verification first?
 
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
 
Back
Top