Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bolton, Ontario, Canada
    Posts
    4

    Unanswered: OpenRecordSet - walk me thru it

    I have a front end database (summary of all expense account submissions) with links to tables in 15+- back end files (individual employee expense accounts). All files are in the same common folder on a network. Needless to say, this front end file is becoming very SLOW.

    According to Microsoft:
    "You can greatly enhance performance when opening the main database ... by forcing the linked database to remain open: ... create an empty table in the linked database, link the table in the main database, then use the OpenRecordset method to open the linked table. This prevents the Microsoft Jet database engine from repeatedly opening and closing the linked database and creating and deleting the associated .ldb file."

    How do I do the OpenRecordset method? I have very limited experience with coding, modules, etc. and I need step-by-step instructions on what to code, where to put it, how to activate it, etc.
    Thanks.

  2. #2
    Join Date
    Nov 2002
    Posts
    150

    Re: OpenRecordSet - walk me thru it

    Create a dummy table in the backend: Dummy

    Create a global recordset variable in a module on the frontend: Global g_rsDummy As Recordset

    In the open event of the of the form that opens when the frontend opens, put:

    Set g_rsDummy = CurrentDb.OpenRecordset("Dummy")

    Keep it open throughout the session.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •