Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008

    Red face Unanswered: MS Access Driver MaxLockPerFile Exceeded

    I wish to translate a large text file (record n = 667,285) into MS Access 2002 using either df Power DBMS/COPY (v.8) or STAT/Transfer v.9. Both programs choke when translating to MS Access. Error message:
    "Error writing file OBDC error in wcase. HY000 - [Microsoft][ODBC Microsoft Access Driver] File sharing lock count exceeded. Increase MaxLockPerFile registry entry. Record count stood at 376,001 with Stat/Transfer v.9.
    Note: I managed to translate the text file to a SAS SAS7BDAT format. The translation from SAS format to Access also failed.

    I would appreciate guidance on how to proceed to deal with MaxLockPerFile!

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Have you tried googling for it?

    Why can't you import the text file from Access itself?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    or alternatovely dump the data into a sutiable format CSV for instance and add the records offline (say overnight) using an autoexec macro to import the data, then do a compact & repair so that the db and indexes using at optimum condition.

Posting Permissions

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