Re: Paradox's FindNearest is faster than ADO MsAccess's Locate!!

From: Ignacio Vazquez (ivazquezATorioncommunications.com)
Date: 12/31/03 

Date: Wed, 31 Dec 2003 16:46:07 -0500

Fatih Tolga Ata wrote:

> Provider is "M$ OLE DB Provider for ODBC Drivers"

> What can I do for improving Ms Access's
> performance like paradox.

Using the Jet provider instead of ODBC is a start, but Access is slow
regardless. 

-- 
Cheers,
  Ignacio

Relevant Pages

  • Re: Issues with linking encrypted tables
    ... >> If it is Paradox, how can I tell what version of Paradox? ... don't give out the password to the actual database: ... I expect it's making an ODBC connection ... 2002 frontend without any ODBC connection. ...
    (comp.databases.paradox)
  • Re: Using Access 2003 to Link to Paradox Data
    ... Don't use the ODBC choice, try using the Paradox choice when linking the ... I have set up an ODBC data source, and I can use Microsoft ...
    (microsoft.public.access.externaldata)
  • Cant access to Access from Paradox
    ... I opened up Access tables via ODBC from Paradox (using native "MSACCES" or ODBC "Microsoft Access" driver). ... This was easy until "Windows 2000", ...
    (comp.databases.paradox)
  • Re: data from Paradox to Excel
    ... Since you are probably using an ODBC drive that was probably written ... data from Paradox to Excel ... Can Excel load Paradox 4x data in an XPpro environment? ...
    (microsoft.public.excel.setup)
  • Re: Pdx v11(?) ODBC
    ... IAC the MS ODBC won't look at it - I'll ... > newest version of the Paradox table format. ... > Microsoft and DataDirect have ODBC drivers for Paradox ... > Brian Abbott wrote: ...
    (comp.databases.paradox)