Results 1 to 7 of 7

Thread: everything just slowed down (a lot!)

  1. Feb 3rd, 2015, 05:08 PM #1
    wengang
    wengang is offline

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    everything just slowed down (a lot!)

    Hi all.

    I have a set of Word macros that I've been writing over several years, a lot of them based on an Access database (.accdb format) that I made a number of years ago. I use ADO 2.8 to connect Word to Access.
    That's been running fine for the past few years in Office 2007 and then 2010.

    Recently, my office upgraded to 2013, and now suddenly all my macros have slowed down big time.
    Any thoughts on what the problem/solution is?

    Thanks
    wengang
    Wen Gang, Programmer
    VB6, QB, HTML, ASP, VBScript, Visual C++, Java
    Reply With Quote Reply With Quote
  2. Mar 31st, 2015, 08:50 AM #2
    wengang
    wengang is offline

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    Re: everything just slowed down (a lot!)

    Bump. Still wondering about this. Went back down to 2010 briefly and everything worked fine again. Went back to 2013 and it absolutely crawls. I find the problem is particularly noticeable whenever a recordset is pulled from the database. Non-database macros are running about the same. Some of the lengthier macros, ones that used to run for one to five minutes, now never finish. I put in a msgbox to monitor progress, and I project that the macro would now have to run for hours to complete. It seems to pull the recordset, but then when iterating through the records, it barely moves. This is in the loop:
    Do until RS.EOF
    xxxxxx
    xxxxxx
    RS.movenext
    loop

    Handling records seems to be throwing it for a loop (pardon the pun).
    Wen Gang, Programmer
    VB6, QB, HTML, ASP, VBScript, Visual C++, Java
    Reply With Quote Reply With Quote
  3. Mar 31st, 2015, 03:23 PM #3
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: everything just slowed down (a lot!)

    did you try upgrading to ACE rather than ADO?
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
  4. Mar 31st, 2015, 03:27 PM #4
    wengang
    wengang is offline

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    Re: everything just slowed down (a lot!)

    Quote Originally Posted by westconn1 View Post
    did you try upgrading to ACE rather than ADO?
    No. I haven't even heard of it. I've been out of the coding game for a few years now.
    Is it complicated? Any drawbacks compared to using ADO?

    Thanks.
    Wen Gang, Programmer
    VB6, QB, HTML, ASP, VBScript, Visual C++, Java
    Reply With Quote Reply With Quote
  5. Mar 31st, 2015, 03:39 PM #5
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: everything just slowed down (a lot!)

    i would believe it is very similar to ADO as far as usage is concerned, it is basically the replacement for ADO in later versions of office and windows

    you should have a reference to ACE, check out connectionstrings.com to find if there are any changes for connecting to database

    google should give much information as to whether this will help you
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
  6. Apr 1st, 2015, 07:35 AM #6
    wengang
    wengang is offline

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    Re: everything just slowed down (a lot!)

    From what I can see, ACE is the replacement for JET, or a newer version of JET. It turned out I was already using ACE in my connection string.

    One line: sText = sText & RS("English")
    takes almost a full minute to process. It processed instantly in Word 2010.
    Wen Gang, Programmer
    VB6, QB, HTML, ASP, VBScript, Visual C++, Java
    Reply With Quote Reply With Quote
  7. Apr 1st, 2015, 08:07 AM #7
    TnTinMN
    TnTinMN is offline
    PowerPoster
    Join Date
    Oct 2010
    Posts
    2,141

    Re: everything just slowed down (a lot!)

    I don't know if this would be an issue or not, but which version of ACE are you specifying in the connection string?

    Provider=Microsoft.ACE.OLEDB.1Y.0
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width