I have a DB in Access. It stores phone numbers and demographic information, like gender, age, ethnicity, etc. It imports data from CSV files.
It has worked fine for a couple months, and now it crashes when importing some files. Breaking the files down into smaller chunks gets it to import them without crashing.
I have done a compress and repair on the DB, and it still crashes.
I have a blank copy of the DB, and I am able to import these same files just fine.
Office is updated, and I have run the office repair tool that checks office and memory, etc.
Any ideas what might cause this?
And/or anybody know the best way to get in contact with MS support? Do they provide free support, or would I have to pay?
Below is some more information about what all I have found....
Access would crash in the middle of imports. And I mean totally crash – not just an error message, like sometimes would happen if there was some bad data in the CSV file.
I tried splitting problem files down, to narrow down what specific record(s) was causing this crash…
I came to find out, that split into small enough chunks, ALL the chunks would import fine, so it is obviously not a problem with the format or content of any records….
It just seems to be a problem of how many records at once. Which is strange considering I imported over a million record file just fine.
I checked to see what happened when I imported into an empty copy of the database – and I was able to import even the large files just fine.
I checked on a different PC, and I was able to import a slightly larger file, but not much.
Also there was not some clear limit. Some files I was able to import 5000 at a time, some I had to break up to 1200 at a time. (overall size in KB did not have a clear limit either)