Solved

Access 2007 Crashes

Posted on 2011-02-17
11
381 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

630 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