Results 1 to 3 of 3
  1. #1

    Huge number of calculations

    Access 2000 - I have a table that has nearly 2 million records in it. I need to read each record perform a custom complicated look up function that I wrote in VBA and then add the result to a column in the table. The routine usually explodes about 60% through the table. The errors lead me to believe that I have exceeded the maximum # of records lock settings. I have changed the number allowed (in VBA) to 1,000,000. Is there any down side to taking this number to 2,000,000 or even greater (I expect the number of records in this table to grow by several orders of magnitude). Is there some way to force the record locks to "flush"? I really don't need to lock the records. This routine only needs to be run once in a blue moon and it can be run "off line" with no multi-user worries. Everything else runs fine (if anyone wants to hear about 3 dimensional arrays of two dimensional rules let me know). Any help would be greatly appreciated.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Redditch, Worcestershire, England
    Thanked 22 Times in 21 Posts

    Re: Huge number of calculations

    If you don't need to enable multi-user access, make sure you open the database in Exclusive mode.

    Then you will not get any locks placed.


  3. #3

    Re: Huge number of calculations

    Jeez that was awful easy

    Kurt <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

Posting Permissions

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