Re: What is best VCL to use with MS Access?

Article View: comp.lang.pascal.delphi.databases

Article #125

Back to comp.lang.pascal.delphi.databases Previous Next

#125

From: Paul Geirnaerdt
Date: Wed, 13 May 1998 00:00

23 lines
1693 bytes

Don,

You don't want to have a quarter of a million records in an Access
database, never. Access is the problem, not the interface to it. Try
another database.

Paul

Don F. Ridgway <dridgway@ix.netcom.com> wrote in article
<3557B34F.17EF@ix.netcom.com>...
> I am using Delphi 3 and want to be able to easily and speedily access
> huge MS Access97 tables.  I see ODBC Express, Titan and the upgraded BDE
> advertised as being able to access Access97 with Delphi.  Does anyone
> out there have experience with any or all of these products to give a
> recommendation?  
> 	I have seen ODBC Express take ten minutes to open a (unindexed)
> quarter-million record Access table.  That is unacceptable.  Why did it
> have to access every record just to open the table?  Is there a cache
> that could be set?  Is Titan faster?  
> 	Need help and any suggestions very welcome.
> Don
>

Technical Details

Message-ID: <01bd7e3e$2eae7820$0bfe6cc3@paul.deltabron.nl>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3557B34F.17EF@ix.netcom.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff75c,c8f4e8c299767c59
X-Google-Attributes: gidff75c,public
X-Google-Thread: ffff5,c8f4e8c299767c59
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,c8f4e8c299767c59
X-Google-Attributes: gid10de66,public
X-Google-Thread: f8256,c8f4e8c299767c59
X-Google-Attributes: gidf8256,public
From: "Paul Geirnaerdt" <paulg@deltabron.nl>
Subject: Re: What is best VCL to use with MS Access?
Date: 1998/05/13
Message-ID: <01bd7e3e$2eae7820$0bfe6cc3@paul.deltabron.nl>
X-Deja-AN: 352802484
References: <3557B34F.17EF@ix.netcom.com>
Organization: NLnet
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop,borland.public.delphi.database.sqlservers,borland.public.delphi.thirdparty-tools

Reply to Parent Message