I am pulling text out of text file, unstringing things, and then inserting the data into a database. Sometimes I have 500 to 1000 items I have to insert. MS Access can't handle the updates in a loop. If I have to use Access, how can I write a script to make this work? <BR><BR>I tried making a for loop after each insert to just cound to 250,000, but this didn't work either. No matter what the time is set to, I get an error that says Access can't open any more tables.<BR><BR>Any ideas?