Database Corruption?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2002, I have a database that stores ~500,000 records monthly.
When importing a new batch of records into this database and running a group
query to remove duplicates, a 'System Resources Exceeded' error occurred.

I checked to see if the DB had somehow made it to the over-the-limit 2GB
mark, and it hadn't. After Compact/Repairing the DB, it was cut down to
45,000 records.

I've looked through my temp files hoping that the missing records would have
been stored somewhere. I'm looking for other ideas to try before I start
re-importing a month's worth of data. Any help would be appreciated!
 
James

I'm a little confused. I'm not aware of anything in the Compact/Repair
process that would delete records. Was it your query that deleted records?

Rather than import, then delete duplicates, would there be a way you could
import/append only non-duplicates?

More info, please...

Jeff Boyce
Microsoft Office/Access MVP
 
I'm a little confused. I'm not aware of anything in the Compact/Repair
process that would delete records. Was it your query that deleted records?
Click to expand...

No. The query ran was a Make Table query that removed duplicates by
grouping. The table that the records are missing from is actually not
referenced in the query at all.

Neither myself or my boss are aware of anything in the Compact/Repair
process that would delete records, either. Which is what makes us both think
corruption.
 
James said:
Using Access 2002, I have a database that stores ~500,000 records monthly.
When importing a new batch of records into this database and running a group
query to remove duplicates, a 'System Resources Exceeded' error occurred.
Click to expand...

I wonder if you'd be best creating a temporary table in a temporary
MDB using the grouping query. Then run an append query to insert
the records into the MDB.
I've looked through my temp files hoping that the missing records would have
been stored somewhere. I'm looking for other ideas to try before I start
re-importing a month's worth of data. Any help would be appreciated!
Click to expand...

No, Access does transaction Commit's and rollbacks for this kind of
stuff so they'd automatically missing once you clicked on the error
message.

(This is also why you can have your tables unchanged when you click on
Cancel to the message you get telling you how many records will be
updated when running Update queries directly. If that previous
sentence makes any sense.)

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Pieter I am having trouble decoding your EMail address. Would you mind
Emailing me so I could reply?
(e-mail address removed)


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Pieter Wijnen"
 
Back
Top