Solved

Access 2007 Crashes

Posted on 2011-02-17
11
377 Views
Last Modified: 2012-05-11
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
Comment
Question by:Xetroximyn
  • 6
  • 5
11 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 34921307
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
 

Author Comment

by:Xetroximyn
ID: 34922035
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
 

Author Comment

by:Xetroximyn
ID: 34927083
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
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 34927372
1.2M is a lot of records.
You may want to run the Compact/repair utility after the import.
0
 

Author Comment

by:Xetroximyn
ID: 34927599
thanks for the quick response!

I tried that and it still crashes
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 34928114
Then I'm stumped.


Can you clearly define "Crash"
0
 

Author Comment

by:Xetroximyn
ID: 34930735
Access crashes.  It asks if I want to send report to microsoft.

See screenshot.

ScreenClip.png
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 34957674
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
 

Accepted Solution

by:
Xetroximyn earned 0 total points
ID: 34970006
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
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 34972146
We/I may have missed something, ... but at this point, your best bet may be to contact MS directly
0
 

Author Closing Comment

by:Xetroximyn
ID: 35025219
Thanks!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Outlook Free & Paid Tools
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now