Article View: borland.public.cppbuilder.database.ado
Article #3294Re: adotable and ms-asscess
From: MarkR
Date: Thu, 17 Oct 2002 10:18
Date: Thu, 17 Oct 2002 10:18
49 lines
2933 bytes
2933 bytes
Hi, I have tried that, but then the cursortype changes from ctDynamic to ctKeyset, which stops changes by other users from being seen. Is it that MSAccess doesn't support multiuser connections? "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message news:3dae5668@newsgroups.borland.com... > Set CursorLocation to clUseServer on TADODataSet (TADOQuery, TADOTable > etc.). > > ---------------------------------------------------------------- > Regards, > Viatcheslav V. Vassiliev > http://www.oledbdirect.com > The fastest way to access MS SQL Server and MS Jet (MS Access) databases. > > "MarkR" <mark.richards8@wapthespamntlworld.com> �������/�������� � �������� > ���������: news:3dad20d3@newsgroups.borland.com... > > I am converting a simple app from paradox (using bde) to use ado and > > msaccess > > In the paradox version, I simply open the table and the app uses dataaware > > controls, including navigator bar. > > When i moved this over to ado and access, it now takes about 30 seconds to > > start up when i make the table active. The connection object is already > > connected. > > It would appear that the application loads the entire contents of the > table > > into memory prior to displaying the data of the first record. > > Does a mechanism exist to stop this? I seem unable to get the direct > access > > like the paradox version. > > any help greatly appreciated. > > > > -- > > BCB Version = 6 (sp2) Professional > > O/S Windows XP Prof > > ------------------------------------------------------ > > "There are 10 types of people in the World, those that understand binary, > > and those that don't." > > [Thanks to TheFatBoy-UMD] > > > > > >
Technical Details
Message-ID:
<3dae8e59$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!TELOCITY!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3dad20d3@newsgroups.borland.com> <3dae5668@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,edb7724cda1aaf9c,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-10-17 03:54:04 PST From: "MarkR" <mark.richards8@wapthespamntlworld.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3dad20d3@newsgroups.borland.com> <3dae5668@newsgroups.borland.com> Subject: Re: adotable and ms-asscess Date: Thu, 17 Oct 2002 11:18:16 +0100 Lines: 51 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 213.107.142.213 Message-ID: <3dae8e59$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1034849881 213.107.142.213 (17 Oct 2002 03:18:01 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!TELOCITY!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail