Re: Persistent Connection to Speed Performance

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

First of all Albert, thank you for your reply. I really don't have the
background for building databases and would never have been able to do what
(little) I have without this Discussion Group. (I've searched and read
postings until my eyes hurt. Although most of what I read is beyond my
comprehension, sometimes I get lucky.) So, it is quite possible that my
design is lacking. I think I have my tables set up and related properly,
but...

I have a copy of the FE from before I appied the "persistent connection" and
the forms open slowly each time. After applying the persistent connection
fix the forms open slowly the first time, but instantly each time after. I
can close the application and reopen and it is the same thing - forms open
slow the first time and quickly each time after. This is an improvement.
The application itself opens quickly either way, it is just the forms I am
having problems with. I am wondering if this is the way the persistent
connection fix is supposed to work - slow on opening the first form and
quickly thereafter?

I am familar with the link you provided and have applied a number of the
tips to my database some months ago. I believe the application itself was
opening slowly before applying these tips. (I set the sub datasheet Name
property on each table in the back-end database to [NONE], I set Track name
AutoCorrect info to off, I shortened the name of the backend database, I
deleted and recreated table links, and I moved the backend as close to the
network share as our IT people would allow - The path is something like
this: \\Rev001-cc\shared\ATD\BE Data
I think I even did a decompile - maybe I should try this again?)

I don't quite understand the mde thing but I'll search the group for more on
this.

"Albert D.Kallal" wrote:

> The persistent connection trick will fix performance problems due to a split
> database.
>
> However, the persist connection trick will NOT fix a poor design.
>
> However, before we try to blame the design, you might want to check out the
> following list of things:
>
> (track auto name correct is a big one, and so is the persistent connection).
>
>
> Check the following list...go through each one:
>
> http://www.granite.ab.ca/access/performancefaq.htm
>
>
> > I added the following line of code the switchboards OnOpen event -
> > DoCmd.OpenForm "frmKeepOpen", acNormal, , , , acHidden
>
> That looks good. However, if you remove this code, and open one form...and
> close it...I bet your application sill opens faster
> (in other words, I not sure the persist trick is helping you!!).
>
> Anther good suggestion would be to try a mde for each front end you put on
> each pc...(that tend to eliminate the track auto name correct issue).
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@xxxxxxx
> http://www.members.shaw.ca/AlbertKallal
>
>
>
.

Relevant Pages

  • Re: Tracking Log In and Log Out times of Users
    ... The fact that the database is on the server should be irrelevant. ... Type mismatch and then highlights Set rst = ... On my startup form, (that opens every time the database is open, ... I then went to the load ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • Re: Code causes error 2486 in access 2000, IPF in 2002
    ... Compact the database to get rid of this junk: ... Allen Browne - Microsoft MVP. ... Windows 98 machine. ... update queries and opens another form - ...
    (microsoft.public.access.formscoding)
  • RE: Mutliple Databases Open for Some Users
    ... No it's not that the user is accidentally opening another database. ... this in the On Click event of the button that opens the mail merge but it ... (ByVal hWnd As Long, _ ... Public Function winGetHWndDB(Optional hWndApp As Long) As Long ...
    (microsoft.public.access.modulesdaovba)
  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)