> 1) How big are you access dbs? After a couple million records access tends
> to go belly up...
The biggest offender is 20 MB, with over 200 tables. Is that "a couple
million records" across all tables?
> 2) are you using connection pooling? Access memory leaks will kill you if
> you have the "maintain db connectoins" box checked in the ODBC
administrator
That's unchecked. But I don't think we'll be looking much further for
'help-Access-hobble-along' tips. We're overdue for a switch.
-- Owen
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
