Flushing data
- From: "rhinoman" <wlevine@xxxxxxxxxx>
- Date: Tue, 12 Apr 2005 08:35:46 -0400
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
.
- Follow-Ups:
- Re: Flushing data
- From: Sylvain Lafontaine
- Re: Flushing data
- Prev by Date: Re: ADP/SQL Server 2000 Security Problem
- Next by Date: vba ado error
- Previous by thread: ADP/SQL Server 2000 Security Problem
- Next by thread: Re: Flushing data
- Index(es):
Relevant Pages
|
Loading
