Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2009
    Posts
    6

    Unanswered: Runtime error 3001: invalid argument help

    Hello,

    Is there anyone could help me about this Runtime error 3001? It really drives me crazy. :eek:

    I was running some codes which involve a big size table (number of observations is over 1 million): ReshapedFX. However, it works occasionally, but returns to me error message most of the time: Runtime error 3001 the other time.


    StrFXcc = " SELECT *, Mid(FXCodeBloomberg,1,3) As ReportCurrency, Mid(FXCodeBloomberg,4,3) As RiskCurrency " & _
    "INTO tempFXFilter FROM ReshapedFX ORDER BY FXCode, Dates "
    DoCmd****nSQL StrFXcc

    I guess it may be related to living memory staff.

    I would really appreciate if someone can give me some hints!

    CissyChen

  2. #2
    Join Date
    Sep 2009
    Posts
    11
    The second argument of RunSQL is to do with using a transaction, and defaults to True. You might want to try it with False.
    Doumented at
    RunSQL Method [Access 2003 VBA Language Reference]

  3. #3
    Join Date
    Sep 2009
    Posts
    6

    Thanks a lot, Waterman!

    Hi, Waterman,

    Thank you so much! It really helps, although not completely solve my problem. I guess there is a limit size for Access db. My db is over 2GB, now I split into two db, plus your suggestions, now it works.


    CissyChen

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    2gb used to be the cut off point for Access databases.
    that may not hold with the most recent version of JET or Access.
    you may want to consider shifting the data storage to another type of data storage mechanism such as as server product.

    SQL server is available as a desktop / personal edition FoC, and of course there are the open source servers such as MySQL
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Sep 2009
    Posts
    11

    Limitations on Access

    http://office.microsoft.com/en-us/ac...868081033.aspx

    gives you the hard limits, from the horses mouth. You may run into soft limits, like performance or convenience before you hit these. Good luck with it.

  6. #6
    Join Date
    Sep 2009
    Posts
    6
    Hi, Healdem and Waterman,

    I really appreciate your help from both of you!!!


    CissyChen

Posting Permissions

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