Access tends to 'abandon' connections... a fair amount of memory loss with any large usage on a server.. Access isn't good at all for shared hosting company environments... Easy way to hose a server...
Find out if they have your DSN maintaining connections ... depending on the application you will or won't want to enable maintain connections... I have found that if your are doing lots of database activity to leave it on with Access... There is also the timeout to maintain DSN connection... try putting that at 1-5 minutes.. probably set at 0 default now... -paris ---------- Original Message ---------------------------------- From: "Tony Weeg" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 16:33:45 -0400 >access has been known at some point (amount of connections or maybe >lines in the database) >to hose up, what that means? not sure, but I know this, if at all >possible, STAY AWAY FROM ACCESS!!!! > >tony > >tony weeg >sr. web applications architect >navtrak, inc. >[EMAIL PROTECTED] >www.navtrak.net >office 410.548.2337 >fax 410.860.2337 > > >-----Original Message----- >From: Andy Ousterhout [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 17, 2003 4:24 PM >To: CF-Talk >Subject: Urgent: Performance Help > > >No, don't recommend Viagra....the problem is I just won't stop..... > >My ISP is accusing me of writing code that keeps threads open long after >they should be closed and are threatening to shut down my site. Good >news is that I don't have many users yet, Bad news is that they can't >give me any details because they don't have their analytical software, >Cognos, up yet. > >Is there a site anywhere that can help we walk through my code and try >to figure out what the problem is? Running MX and Microsoft Access. It >runs fine as a single user on my PC. > >Thanks for anything you can give me.... > >Andy > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137372 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com