Connecting Tech Pros Worldwide Help | Site Map

Persistent Connections - always a good thing?

  #1  
Old May 16th, 2006, 05:15 PM
Paul Wagstaff
Guest
 
Posts: n/a
Access 03 Runtime / Win XP

Hi folks I wonder if I can tap the wizards for some general advice..

What are the risks/penalities/drawbacks for having a persistent connection
to a back-end mdb?

thanks in advance,
Paul


  #2  
Old May 16th, 2006, 09:35 PM
paii, Ron
Guest
 
Posts: n/a

re: Persistent Connections - always a good thing?


I saw a huge performance improvement when opening forms and reports, with
the backend on a Windows 2003 server. There was no difference when the
backend was on a Novell 3.x server.

I saw an increase in backend corruption until I change the open table to one
that is only used to for the persistent connection.

"Paul Wagstaff" <paulwagstaff@blueyonder.co.uk> wrote in message
news:eOmag.157739$xt.76696@fe3.news.blueyonder.co. uk...[color=blue]
> Access 03 Runtime / Win XP
>
> Hi folks I wonder if I can tap the wizards for some general advice..
>
> What are the risks/penalities/drawbacks for having a persistent connection
> to a back-end mdb?
>
> thanks in advance,
> Paul
>
>[/color]


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exceed Persistent Connection Limit on a ServicePoint? Steve - DND answers 5 November 15th, 2005 01:46 PM
mysql_pconnect() Do persistent connections ever die? Randell D. answers 5 July 20th, 2005 12:29 AM
mysql_pconnect() Do persistent connections ever die? Randell D. answers 1 July 20th, 2005 12:29 AM
DB - persistent connection? Derek Fountain answers 3 July 17th, 2005 12:43 PM
mysql_pconnect() Do persistent connections ever die? Randell D. answers 3 July 17th, 2005 01:29 AM