Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old May 16th, 2006, 05:15 PM
Paul Wagstaff
Guest
 
Posts: n/a
Default Persistent Connections - always a good thing?

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
Default 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]


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,338 network members.