Performance Issues

[Sharkbyte]

I have been experiencing performance issues, on a billing database I am
writing.

I perused the post history, and found several good suggestions.

One, in particular, was to open a dummy table, to a linked db, and leave it
open so Access didn't need to create a link for each call. I can easily see
a 50% increase in accessing speed, when doing this.

I am curious, though, is there a way to hide the table? I couldn't seem to
do it, though I was experimenting with something similar to hiding a form.

Also, there have been several references to this document:

http://www.granite.ab.ca/access/performancefaq.htm

It seems to be unavailable. Is the site no longer hosting? Does anyone
have a copy they could email me? (e-mail address removed)

Thanks, in advance.

Sharkbyte

 

[Douglas J. Steele]

The URL you reference works fine for me. I just double-clicked on it, and
got to Tony's site.

You don't need to open a table for this to work. Open a form that's based on
a table, and open that form Hidden. Tony talks about this at
http://www.granite.ab.ca/access/performanceldblocking.htm

 

[chemicals]

Doesn't the switchboard already function as the bound form in the example
below? The switchboard is always open...?

 

[Albert D. Kallal]

Doesn't the switchboard already function as the bound form in the example
below? The switchboard is always open...?

It might. Often, the switchboard table is STILL in the front end part...and
thus it does not make a persistent connection....

If the switchboard table is in the back end...then yes...it is making a
persisting connection. So, the answer depends on where the switchboard table
is located.....