Article View: borland.public.cppbuilder.database.ado
Article #2122Best way for multiple users to update the database?
From: Simon Elliott
Date: Sat, 08 Nov 2003 09:24
Date: Sat, 08 Nov 2003 09:24
17 lines
1575 bytes
1575 bytes
I have an application with lots of threads, each doing data acquisition. Each thread will put the data into an MS Access database using the BCB6 ADO components. The problem is, if one thread has started a transaction or started to update the database, the next thread will give an exception when it tried to do likewise. Since this is a single program with multiple threads updating the database, it's probably simpler to use Synchronise or critical sections or queue the updates. But if it were a multi-user system, what are the options for doing record locking etc? -- Simon Elliott http://www.ctsn.co.uk/
Technical Details
Message-ID:
<bfGDSHAOZLr$IwW6@courtlands.demon.co.uk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!courtlands.demon.co.uk!simonShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,78117e9580d18fb0,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-11-08 01:39:04 PST Message-ID: <bfGDSHAOZLr$IwW6@courtlands.demon.co.uk> Date: Sat, 8 Nov 2003 09:24:30 +0000 From: Simon Elliott <simon@nospam.demon.co.uk> Reply-To: Simon Elliott <news@nospam.demon.co.uk> Newsgroups: borland.public.cppbuilder.database.ado Subject: Best way for multiple users to update the database? Lines: 23 Organization: Courtlands Technical Services MIME-Version: 1.0 X-Newsreader: Turnpike Integrated Version 4.02 U <aLIvuQCpEWZ0Tu7eytpxRhrSSE> NNTP-Posting-Host: 158.152.154.121 X-Trace: newsgroups.borland.com 1068283491 158.152.154.121 (8 Nov 2003 01:24:51 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!courtlands.demon.co.uk!simon