Network ADO with MSAccess database

Article View: borland.public.cppbuilder.database.ado

Article #4594

Back to borland.public.cppbuilder.database.ado Previous Next

#4594

From: Don Wilcox
Date: Thu, 01 Nov 2001 21:50

17 lines
1676 bytes

My application runs in several components on different machines on a local
net. The program on each machine performs a different task, and the various
programs need to detect changes made to the database by other programs, and
respond accordingly.

Unse BDE, I just called Refresh(), and the new data was loaded. Under ADO, I
am having a couple of problems. First, Refresh() is really slow, and so I do
not want to call it any more than necessary. Second, not all changes seem to
show up.

My question is, is there any way to configure the connection or the tables
so that the changes are automatically seen? Also, will this go away when I
deploy using SQL server or Oracle (or even [shudder] MSDE)?

Thanks,

Don Wilcox

Technical Details

Message-ID: <3be1c3c2_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d87f49aae4b3d218,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-01 14:03:15 PST
Reply-To: "Don Wilcox" <dwilcox@dfsaz.com>
From: "Don Wilcox" <dwilcox@dfsaz.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Network ADO with MSAccess database
Date: Thu, 1 Nov 2001 14:50:01 -0700
Lines: 19
Organization: DFS, Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 24.221.124.61
Message-ID: <3be1c3c2_2@dnews>
X-Trace: dnews 1004651458 24.221.124.61 (1 Nov 2001 13:50:58 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews