Solved

Access 2007 Crashes

Posted on 2011-02-17
11
378 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
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: 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…

777 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