I once worked with an Access DB that would hit 100K + records in one table on a regular basis. It performed fine. However, it was a rather speciallized app, and I think it was primarily doing inserts into the table. But, I did need to reference the table to extract information through a second application - never had any problems with the table.
HTH. Shawn Grover -----Original Message----- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 7:40 AM To: CF-Talk Subject: Access table record limit? Does anyone know what a practical limit of records should be in an Access table? The reason I ask is that I have a table for a feature I am implementing that with some really broad estimates of mine could hit 20,000 records in a year of heavy usage (for this app, which really wouldn't be heavy usage relatively speaking...). Any higher than that and I'd insist on SQL Server for performance. This particular table has just 4 fields, and is nicely indexable... I've seen some outrageous Access databases in my time that worked, but I can't remember if I've seen 20k records in one table. jon ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists