MaxLocksPerFile Exceeded for some but not others

L

Lee Robinson

I ran into this problem when dealing with Do Not Call lists. I am able to
import the Federal Do Not Call list of 50 million telephone numbers with no
problem. However, when I tried to import another list of numbers and
addresses with only 13,000 records, I received the error about the exceeding
the MaxLocksPerFile. Both are being imported via a DoCmd.TransferText
command specifying an import spec. I was able to get around the problem
with the SetOption command but I was wondering why the problem came up with
the 13,000 record file and not the 50 million record file. Anyone have an
idea?

Lee Robinson
former Access MVP
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import multiple csv and add filename in additional field 4
Not enough space on temporary disk, MaxLocksPerFile, MaxBufferSize 5
import ignores the text format in table's field 1
#URGENT CHALLENGE: HOW TO PRODUCE A LIST OF TOTAL DIFFERENT RANDOMNUMBERS ONES OF THE OTHERS IN EXCE 3
Dealing with unparseable records 4
Import Woes - dealing with unimportable records 0
all #'s i could call, minus #'s i cant, add back #'s i can 3
editing vcf files with Outlook 2

Top