Maiximum number of records

[mikemaki]

Hi-
Im importing 80,000 records into a table and then using a query to reformat the records and append them to a second table. The import works, but the append quits after about 6500 records. Is there a limit to the number of records an ACCESS query can handle?

 

[KeithG]

Access can handle up to 2 gigs of info minus the space your database objects consume.

 

[gemma-the-husky]

are yuo sure its not a key problem with the append query

ie the append query is rejecting duplicates/invalid keys

 

[mikemaki]

For anyone interested -
My problem had to do with the overhead in the append query. My table indexes were not set up correctly and I was doing a Group By on every field in the query to eliminate duplicates. A normal file of about 3,000 records would run in a couple minutes, but 80,000 could run for days without results. I removed the Group By and fixed the indexes. 80,000 records now takes about 15 minutes.