Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

Access 2007 Crashes

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)
0
Xetroximyn
Asked:
Xetroximyn
  • 6
  • 5
6 Solutions
 
Jeffrey CoachmanMIS LiasonCommented:
How big is the database itself?
If it is approaching the 2GB limit, then this might be a factor...

try the basics:

Are you running the Compact/Repair utility on a regular basis?
Create a new DB and import all the objects.
Make sure you have all the Service packs installed for Office *and* Windows.
0
 
XetroximynAuthor Commented:
Thanks!

DB is less than 300MB when compacted.

I am repairing and compacting.

I installed all office and windows updates.

Right now I am running an export and will import all items into a copy of the "fresh/empty" DB

0
 
XetroximynAuthor Commented:
So I just exported everything to CSV, and then imported it into a fresh blank copy of the DB.   It imported fine with its 1.2 million records.  But then I import another file with less than 10K records, and it crashes again.  

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanMIS LiasonCommented:
1.2M is a lot of records.
You may want to run the Compact/repair utility after the import.
0
 
XetroximynAuthor Commented:
thanks for the quick response!

I tried that and it still crashes
0
 
Jeffrey CoachmanMIS LiasonCommented:
Then I'm stumped.


Can you clearly define "Crash"
0
 
XetroximynAuthor Commented:
Access crashes.  It asks if I want to send report to microsoft.

See screenshot.

ScreenClip.png
0
 
Jeffrey CoachmanMIS LiasonCommented:
Final thing to try:
1. Scan for viruses
2. Uninstall Office, Reboot, Reinstall Office.

MS tech support contact info and pricing changes from time to time.
And there are different Channels depending on what product you purchased.
It may cost you, but I have heard that they can almost always get the issue resolved.
0
 
XetroximynAuthor Commented:
Turning off record locking, (this database is single user) makes it so it will not crash.  But everytime I open it, I have to run off record locking again.   It wont seem to stick.  

Any ideas?
0
 
Jeffrey CoachmanMIS LiasonCommented:
We/I may have missed something, ... but at this point, your best bet may be to contact MS directly
0
 
XetroximynAuthor Commented:
Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now