Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23
  1. #16
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Close! WF.

    Don't expect to hear from me any time soon, lol.

  2. #17
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    WOW!! After following all the recommendations - mainly changing the key structure on both tables - the update query was finished in minutes. It took longer to save the table changes (about 30 minutes) than it took to run the query - less than 15 minutes!! Just goes to show, do things the way Access wants and voila, good stuff happens.

    Thanks all for your help and good advice.

  3. #18
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    to understand the importance of proper indexing, take a look at post #6 of this thread

    https://www.accessforums.net/showthr...d+wise+foolish

  4. #19
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Good article. Amazing how brains leak and we need to be reminded of things every now and then!

  5. #20
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  6. #21
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Another question on this same thread (am I supposed to start a new one?).

    What difference if any does the size of the fields in linking make to the running time of the query? Say there is a text field of 20 char linked to a text field of 255 char, would it matter? It is the same field, just two dba's (or one dba and one non-dba!).

  7. #22
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    would not expect it to make any difference

  8. #23
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Good to know, thanks.

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

Similar Threads

  1. Replies: 16
    Last Post: 01-18-2016, 03:58 AM
  2. Speeding up record search
    By Paul H in forum Forms
    Replies: 22
    Last Post: 11-03-2015, 06:44 PM
  3. speeding up queries
    By frustratedwithaccess in forum Access
    Replies: 13
    Last Post: 10-10-2014, 12:08 PM
  4. Speeding up Table Linking Times
    By cbh35711 in forum Access
    Replies: 2
    Last Post: 03-27-2012, 03:54 PM
  5. Speeding up Macros
    By salisbut in forum Programming
    Replies: 3
    Last Post: 07-19-2010, 04:02 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