By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,029 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,029 IT Pros & Developers. It's quick & easy.

Database Shuts Down Upon Query

P: 2
Hello, I'm using Access 2003 to work on cleaning up and modifying records in a database with about 7k records.

I've been trying to run a Make-Table Query on the table with 7k records, but every time I run it, Access almost instantly pops up the "Microsoft Access has encountered an error and will be closing. Please send error report to Microsoft" etc.
I thought it was because there were too many records, but 7k doesn't seem to bad compared to others I've seen, and the size of the database is about 900 MB (under the 2GB limit of Access).

Even so, I Compacted/Repaired the database to around 300 MB, but that made no difference.
Any help would be appreciated, thank you.
Aug 5 '10 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,769
Welcome to Bytes!

I can only guess there is a corruption in there somewhere. Sometimes these things can be sorted by a Compact/Repair, but not always. Is your database compiled?
Aug 5 '10 #2

P: 2
Thanks for replying :). By compiled do you mean have I compiled my code in the module? I have, with no errors.
Aug 5 '10 #3

NeoPa
Expert Mod 15k+
P: 31,769
That is what I mean yes. I was hoping maybe it would find a problem for you.

Otherwise, using a backup copy of the database, try deleting various of the objects until you discover which of them may be corrupted. From there, remove this item from another good copy and re-add it either by copy pasting the code or manually. This depends to a certain extent on the type of object of course. You could also try importing the object across from your original, but in my experience that simply causes the problems to come back.
Aug 5 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.