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

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]