"There Isn't Enough Disk Space or Memory" Error

Posted on 2004-11-22
Last Modified: 2008-02-26
I have a query that gets the error "There Isn't Enough Disk Space or Memory to Undo the Data Changes this Action Query is about to Make".
This is ok, but I don't want to recieve this message in the future.  

I have tried changing the registry and increasing the MaxLocksPerFile and have also turned off the UseTransaction Property on the Query.

Do you know how I cuold disable this specific error message?  It doesn't really matter to me if I can Undothe Data Changes the action query is about to make.

Question by:jdlugge
    1 Comment
    LVL 41

    Accepted Solution

    You can't disable the prompt in particular. However, if you are executing the query in VBA, you can either use:

    DoCmd.SetWarnings False
    DoCmd.OpenQuery "MyQuery"
    DoCmd.SetWarnings True

    CurrentDb.Execute "MyQuery"

    Note that this second will only work if the query has no parameters. If it does, you will have to execute it using a different methodology (setting the QueryDef's parameters and then executing it).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now