Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    disk full error (Access 2002)

    Can anyone explain why I would get a disk full error in the middle of a procedure? I have checked an the disk is NOT full. Is this some kind of write error? I was able to click through this error and my report completed, but the data was incomplete, naturally.

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: disk full error (Access 2002)

    Technically, you may not have enough RAM to run the report, but I am pulling at straws here.

    Have you checked your queries that drive the report for a cartesian product to ensure that you are not generating data that isn't necessary. I have "Crashed" many different systems by having invalid joins and doing just this. I would cheat by putting a Select Distinct... in the query to get rid of the duplicates, but I ultimately had to fix the queries when the systems crashed or I received the not enough memory error.

    You may also have too many different applications open at once. Try closing some of them.

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: disk full error (Access 2002)

    thanks for your reply, Gary

    This is being run on a Citrix server, so it is possible that I might not have enough RAM on the server. This is a very intermittent problem--probably once in 25 runs or so.

    I just need to add an error handler to catch this and terminate the report altogether and instruct the user to begin again. I think the error happens at different points in the code and in different procedures, although I'm not sure. How can I write an Error handling procedure that would catch this one error regardless of which module or procedure it occurred in?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: disk full error (Access 2002)

    You can't unless you've built a code framework for your application or your error handling is done through custom classes. Access has granular error handling. It doesn't provide a global error handler.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: disk full error (Access 2002)

    I was afraid that was the answer I would get. Thanks for letting me know.

Posting Permissions

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