🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #3294

Re: adotable and ms-asscess

#3294
From: MarkR
Date: Thu, 17 Oct 2002 10:18
49 lines
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-mail
References: <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