Article View: borland.public.cppbuilder.database.ado
Article #61Re: Using Access database in a network with ADO
From: Mark Richards
Date: Wed, 28 Nov 2007 10:42
Date: Wed, 28 Nov 2007 10:42
11 lines
1664 bytes
1664 bytes
One method is to set up a timer to peridoically flush any changes, close the connection and then open it again. A second method, and one which I use myself is every time a user selects to do a new task in your application, for example if they change to a secondary screen, or select an option from a menu, then the first cause of action could be to flush any buffers, close the database connection, open it and then launch the action the user has selected. This would ensure the changes up to that point made by other users are displayed or calculated correctly. hope that helps
Technical Details
Message-ID:
<474d460b$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!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> <474ca07a@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 From: "Mark Richards" <markcr@wapthespamntlworld.com> Newsgroups: borland.public.cppbuilder.database.ado References: <4749c64f$1@newsgroups.borland.com> <474be427$1@newsgroups.borland.com> <474ca07a@newsgroups.borland.com> Subject: Re: Using Access database in a network with ADO Date: Wed, 28 Nov 2007 10:42:19 -0000 Lines: 13 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 81.103.92.168 Message-ID: <474d460b$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1196246539 81.103.92.168 (28 Nov 2007 02:42:19 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail