What is best VCL to use with MS Access?

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

Article #127

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

#127

From: Don F. Ridgway
Date: Mon, 11 May 1998 00:00

12 lines
1508 bytes

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: <3557B34F.17EF@ix.netcom.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,c8f4e8c299767c59,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: ff75c,c8f4e8c299767c59,start
X-Google-Attributes: gidff75c,public
X-Google-Thread: f8256,c8f4e8c299767c59,start
X-Google-Attributes: gidf8256,public
X-Google-Thread: 10de66,c8f4e8c299767c59,start
X-Google-Attributes: gid10de66,public
From: "Don F. Ridgway" <dridgway@ix.netcom.com>
Subject: What is best VCL to use with MS Access?
Date: 1998/05/11
Message-ID: <3557B34F.17EF@ix.netcom.com>
X-Deja-AN: 352400546
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: Netcom
X-NETCOM-Date: Mon May 11  7:24:46 PM PDT 1998
Mime-Version: 1.0
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop,borland.public.delphi.database.sqlservers,borland.public.delphi.thirdparty-tools