Post reply

Access Procedure Size limit - DTS package

  • May 23, 2006 at 4:06 pm

    #67423

    Hi,

    Probably a cross forum problem but as its an Access issue I will post here.

    I have a stock file importing from an accounting system with over 300+fields.  The DTS save to vbscript works well on other tables but runs into a Procedure Size problem for this particular file when used in Access.

    What is the Procedure size limit in Access?

    Does anyone have a workaround that will produce less code? DTS is rather vebose.

    TIA

    Richard

     

  • May 23, 2006 at 4:39 pm

    #639632

    I know that when you use linked server with access that you often have to change the maxlocks per file if you are importing/exporting a lot of data otherwise is just fails.

    Its in the registry somehwere under jet and is usually set at about 10000 but I've had to raise it to significantly more than this for the access database I import/export stuff to on a regular basis.

    There's an article on the MS web site (somewhere) that tells you what to change.

     

    hth

     

    David

  • May 23, 2006 at 11:45 pm

    #639678

    David,

    I've had that problem before when stress testing Access - the number/pool of ports open had to be increased and also the timeout lenght changed so that they would become available sooner but this is a compilation error in Access where the number of lines in a procedure is just too much.

    Thanks for your contribution.

    Richard

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply