Article View: borland.public.cppbuilder.database.ado
Article #60Re: Using Access database in a network with ADO
From: Mario Sernicola
Date: Tue, 27 Nov 2007 22:55
Date: Tue, 27 Nov 2007 22:55
33 lines
2233 bytes
2233 bytes
Is there a solution in order to work in multi-user mode? I think is a problem due to the cache of the TAdoTable and TAdoQuery components. Mario Sernicola Mark Richards wrote: > I may be wrong, but you may have to force a refresh peridoically, this may > even need to be a close / open of the dataset if it is to pick up changes by > other users. It really isn't suitable for multi-user work in my opinion! > "Mario Sernicola" <mariosernicola@libero.nospam.it> wrote in message > news:4749c64f$1@newsgroups.borland.com... >> Hi, >> >> I wrote an ADO application that use a MS Access database. I'd like to use >> it in a LAN where there are 2-3 computers on which run my application that >> use the same database. >> >> I've seen that when one of this application write on db, the others >> applications don't see any modification of data. My goal is that all >> applications must have the same view on db at the same time. >> >> I use a TAdoConnection component that is connected with database and >> TAdoTable and TAdoQuery components that are connected with AdoConnection. >> >> How can solve this? >> >> Thanks >> >> Mario Sernicola > >
Technical Details
Message-ID:
<474ca07a@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4749c64f$1@newsgroups.borland.com> <474be427$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,227f63e8df0318bf X-Google-Attributes: gid10698b,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Date: Tue, 27 Nov 2007 23:55:58 +0100 From: Mario Sernicola <mariosernicola@libero.nospam.it> User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: Using Access database in a network with ADO References: <4749c64f$1@newsgroups.borland.com> <474be427$1@newsgroups.borland.com> In-Reply-To: <474be427$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 87.19.248.72 Message-ID: <474ca07a@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1196204154 87.19.248.72 (27 Nov 2007 14:55:54 -0700) Lines: 33 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail