Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007

    Unanswered: Connecting files larger than 2GB via ODBC

    Hi Guys,
    I am looking for a solution to this problem I am facing for a few days. I am trying to connect to a third party database and download table using ODBC.
    But once the table size is more than 2 Gb, I get the error "Failed to Create Recordset".
    Can anyone tell me how to increase the size of the temporary jet file or what can I do to resolve this problem.
    Any windows setting I am missing.

    A quick response from you gurus will be highly appreciated.

    Thanks a million in advance.

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    What TYPE of third-party database?

    Is your front-end VB6? Or Access/VBA?

    Are you using ADO (preferred) or DAO?

    What do you mean by "Download Table" ?

    Is you post the code, it would help.
    Last edited by loquin; 03-26-07 at 13:18.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts