Append Query stops

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

I have an append query that adds current year data
records to a table with all previous years data records.
The table currently has about 215,000 records. The
append query stops about 1/3 of the way through the
process. Is there a maximum # of records allowable in a
table? How can I get around the problem?

I've got 2 gig of spare space on my hard drive and have
already repaired & compacted the database. I would
appreciate any help!
Thanks
 
Nancy

You don't say how large the database is.

You don't say what happens when the append query "stops".

While there is no set limit on the number of records, there are practical
limits (database size, see question #1 above). And record size is also
limited to, I believe, 2 Kbytes.

Your ?history? table has 215,000 records -- how many are you trying to add
from your "current" year table?

If no one ever needs to look up historical info, your design may work fine.

If someone ever needs to compare previous year(s) to current, your design
requires connecting the current and history table together.

Is there a reason you don't leave all the records in a single table, index
on a DateOfSomething field, and use a query to find "current" records?
 
Back
Top