There is a lot of conflicting information on how to properly set up an
Access datasource. For me anyway, I've found that Access sites are much more
stable when the database connection is NOT persistent, and the max number of
connections is set to around 5.
Regards,
Chris
------------------------------------------------------------------------
On 8/10/00, Dave Watts penned:
>This article only applies to Microsoft Access. If you're using Access,
>maintaining database connections may cause memory leak and stability
>problems. Of course, if you're using Microsoft Access, you may have all
>kinds of problems that you can't fix by dropping database connections.
There was in article in CFDJ that said ALWAYS maintain database
connections with Access and set the max number of connections to 1. I
set mine to 2 just to be risqu�. :)
--
Bud Schneehagen - Tropical Web Creations
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
