[AccessD] Persistent Connection question

[Janet Erbach]

The users certainly do notice a speed difference with the persistent
connection, that's for sure.  That, combined with changing the main tables
in the app to have 'none' for the subdatasheet name, have made a huge
difference.

But this flaky behavior when running the app from the menu has eaten up
almost all of my time for the last 3 weeks and it seems it was all because
of that line of code when the form opened.  I wonder if it was because the
variable was NOT a static one...

Anyway, things have settled down now that I've bound the form to the
backend by way of keeping the connection persistent.



On Sat, Apr 4, 2015 at 11:17 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> Brilliant.
>
> Jim
>
> ----- Original Message -----
> From: "Janet Erbach" <jerbach.db at gmail.com>
> To: "Database Advisors" <accessd at databaseadvisors.com>
> Sent: Friday, April 3, 2015 1:40:52 PM
> Subject: [AccessD] Persistent Connection question
>
> Hello all -
>
> I've finally discovered what's been causing extremely flaky behavior in a
> database I've been wrestling with for the past 3 weeks.  It was one line of
> code in the menu form that opens with the app:
>
> Dim dbsAlwaysOpen As DAO.Database
> Set dbsAlwaysOpen =
> OpenDatabase("S:\MAINT\ToolingTech\dbToolingTechData.accdb", False)
>
> Some forms were not populating consistently, records were sometimes being
> dropped during select and insert queries, other forms needed to be manually
> refreshed repeatedly in order to display all records, things like that.
> The app worked fine when opened in design view - not when run from the
> menu.
>
> This morning I bound the menu form to a small, 'fake' table in the backend
> and everything seems back to normal now.
>
> Why would this method of establishing a persistent connection cause
> issues?  I found code like this on a couple of websites when I was pursuing
> serious speed issues with the app.
>
> Thanks!
>
> Janet Erbach
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>