Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Access 2007, sp2
    I'm still to get full details but the immediate error was:
    There isn't enough memory to complete the Automation object operation on the Document object.
    Close unneeded programs and try the operation again.
    For more information on freeing memory, search the Microsoft Windows Help index for 'memory, troubleshooting'.

    Just going to search further but any knowledgable suggestions would be welcomed.
    Thanks
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The error could mean what it says (shortage of RAM) but it could also be caused by database bloat or corruption.

    Try Compact and Repair first (Office button > Manage > Compact and Repair).

    If that doesn't help, you could try the following:
    - Create a blank new database.
    - Import all database objects from the problem database.
    - Set the startup options and the VBA references as in the old database.
    Hopefully the problem won't occur in the new database.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='795250' date='28-Sep-2009 12:24']The error could mean what it says (shortage of RAM) but it could also be caused by database bloat or corruption.

    Try Compact and Repair first (Office button > Manage > Compact and Repair).

    If that doesn't help, you could try the following:
    - Create a blank new database.
    - Import all database objects from the problem database.
    - Set the startup options and the VBA references as in the old database.
    Hopefully the problem won't occur in the new database.[/quote]
    Thanks Hans, compact and repair appears to have resolved error, although I think it would be prudent to copy and clean as well.
    I've inherited management of the database from a 'rogue' db creator (I cannot use the term developer) so there's lot's to be cleaned up.

Posting Permissions

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