> 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.
I'd be more worried about the number of concurrent users than the number of records. Twenty thousand records isn't all that many. In any case, though, you might want to look at MSDE, which is essentially SQL Server without Enterprise Manager. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
