By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Persistent Connections - always a good thing?

P: 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
May 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <pa**********@blueyonder.co.uk> wrote in message
news:eO*******************@fe3.news.blueyonder.co. uk...
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

May 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.