Persistent connection between FE & BE for better performance

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

Hi all,

I have a question about something I’ve been reading regarding keeping a
persistent connection between the FE and BE of a split database. (I’ve seen
the info in a couple of places but most recently in the MS-Access Performance
FAQ).

The information mentions always keeping a table open. I have a switchboard
that I created using the Switchboard Manager. I am assuming that because of
the switchboard form, the switchboard table is always open. The FAQ mentions
that the presence of an .ldb file indicates a persistent connection. I
currently have my database open and see .ldb files for both the BE and FE.

Am I correct in assuming that because of my switchboard form and related
table I have a persistent connection and, thus, this will not contribute to
poor performance when I deploy the database on the LAN? (I recognize that I
may have other issues that will affect performance but I guess I’ll cross
those bridges when I get to them.)

FWIW, if I’m correct, I can’t think of how my users could lose this
persistent connection (but then I’m no expert in Access). I’ve employed USL,
turned off all menu access (from Tools\Startup), don’t allow user access to
the database window, and am considering taking advantage of shiftkey2000.mdb
that I found on the Internet to disable the shift key. Because of this, the
users must do everything through the switchboard window. I’ve even disabled
the red X on the switchboard form so they have to use the Exit button -
though I suppose they could just close Access instead.

Thanks in advance for any and all help!

Chris


.

Relevant Pages

  • Re: Persistent connection between FE & BE for better performance
    ... My key fields are autonumber/long integer so I should be okay on that front. ... My database is rather small at this point with only a few relationships so ... is the table that the switchboard is based on in your FE or your BE? ... that the presence of an .ldb file indicates a persistent connection. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Persistent connection between FE & BE for better performance
    ... 8-part free tutorial that covers essentials in Access ... My database is rather small at this point with only a few relationships so there are few indexes. ... is the table that the switchboard is based on in your FE or your BE? ... The FAQ mentions that the presence of an .ldb file indicates a persistent connection. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Global variables disappear
    ... I have a training database, which I am still making alterations to and am disturbed that sometimes while working on forms etc my Global variables are suddenly all zero length strings. ... The OnOpen event of the Switchboard form calls a number of functions located in the SysConfiguration module which sets the Global variables to their appropriate values. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2003 database On Open Event Error
    ... Are you aware that the Switchboard wizard in Access 2007 does NOT use ... any VBA code to create the Switchboard form, ... I tested an Access 2003 database that behaved the way you describe in your ... Private Sub Form_Open ...
    (microsoft.public.access.forms)
  • Switchboard form not opening
    ... I'm using a switchboard (the one from the Contacts database). ... If I expand the main Access screen and select the Switchboard form, ... all is well (the main Access screen minimizes and the Switchboard opens). ...
    (microsoft.public.access.forms)