Solved

Access 2007 Crashes

Posted on 2011-02-17
11
380 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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
 
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

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!

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

696 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