Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    JRodko is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Oct 2018
    Posts
    127
    Hi Vlad,



    Seems to be working quite nicely with one issue. I have two sets of linked tables and two sets of queries. The first set is the one that is intermittently available, but the second is always available. I can't run this stuff for the second set because it can't make links for the first set and the whole thing fails. I am going to attempt to remedy this by removing the second set from the hlpBE_Tables and re-link them manually. I will report back.

    I will have to remove the PublicSUb cvGenerateListOfLinkedTables() correct? Otherwise it will just repopulate.

  2. #17
    JRodko is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Oct 2018
    Posts
    127
    Left it in actually because I saw no reference to it. This works like an absolute charm. Thank you Vlad! Marked as SOLVED.

  3. #18
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi,
    No, that sub is called manually to populate the table, it is not called by any other sub or function. And don't relink them manually if there are a lot of them, make a copy of the table (make sure you keep the original name for this one) and remove the ones that are NOT always available and add Stop after SET_LINKS:
    Code:
    If SET_LINKS = True Then Stop
    Now they should be all linked, stop the code and remove the "Stop". Finally delete this temporary copy of the table and delete the records for these "always available" tables from the main table, leaving only the "intermittently available" ones.
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #19
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You're very welcome, glad to hear it works!

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Speed Slow with Linked Tables
    By mindbender in forum Database Design
    Replies: 7
    Last Post: 09-05-2018, 10:53 AM
  2. Replies: 1
    Last Post: 01-20-2016, 10:58 AM
  3. Replies: 6
    Last Post: 12-06-2015, 04:47 PM
  4. Replies: 3
    Last Post: 06-29-2012, 08:58 AM
  5. linked tables - slow
    By wowiwi in forum Access
    Replies: 5
    Last Post: 10-01-2011, 12:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums