Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Office Dev Center >
> 
> 
persistent connection

Unanswered persistent connection

  • Wednesday, April 11, 2012 8:42 PM
     
     
    Sign In to Vote
    0

    I have a FE / BE Access Application accross our network and was doing some research into optimizing the speed.  One consideration I came accross was to create a "Persistent Connection" by creating a bound form in the FE to one of the underlying linked tables in the BE and set it as the startup form and place it in a hidden mode.  Having it always open and bound creates the Persistent Connection I am guessing.

    I already have a start up form that remains open throughout the User Session, but it is not a bound form.  However, it does have some DLookup Function on it that looks at and retruns some values out of my "Authorized Users" table (linked table).  Are these DLookup's sufficient to create the Persistent Connection or do I have to go the "Bound Form" route?

    Ken.

     

All Replies

  • Wednesday, April 11, 2012 8:56 PM
     
     
    Sign In to Vote
    0

    No, a DLookup will not create a persistent connection.

    Regards, Hans Vogelaar