Article View: borland.public.cppbuilder.database.ado
Article #3982Re: Access Alert
From: Jerry Irons
Date: Thu, 02 May 2002 12:39
Date: Thu, 02 May 2002 12:39
24 lines
1511 bytes
1511 bytes
Hi, Use TADODataset MS JET as provider in connection string cursor location UseServer commandtype TableDirect if possible This should help quite a bit. -Jerry On Wed, 1 May 2002 23:10:47 +0200, "Andre Venter" <andre@hacker.co.NOSPAM.za> wrote: >Im currently using TADOQuery and TADOTable for using access databases, >and finding the speed a less than satisfactory... i'm know it can be alot >faster, I have used access in VB before and that worked very efficiently. > >Does anybody have any comments, or suggestions on how to speed this up? >I can only presume using another method of using access databases? >
Technical Details
Message-ID:
<inc2dugu6fqn5eubu06ngh807n09vr7j69@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!sjc-peer.news.verio.net!news.verio.net!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3cd0595d_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,78a19b2c04d2c365 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-05-02 05:41:37 PST From: Jerry Irons <JIrons@compuserve.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: Access Alert Date: Thu, 02 May 2002 08:39:27 -0400 Message-ID: <inc2dugu6fqn5eubu06ngh807n09vr7j69@4ax.com> References: <3cd0595d_1@dnews> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.54.10.7 X-Trace: dnews 1020343220 24.54.10.7 (2 May 2002 05:40:20 -0700) Lines: 25 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!sjc-peer.news.verio.net!news.verio.net!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews