Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Posts
    108

    Red face Unanswered: Unexpected Error 32790

    Anyone have any idea where to begin ? When compiling code, I get this error. And so far, the only solution I have found, is to delete the whole database, go to a backup and then make the changes again and hope for the best. Most of the time, it will work, but I have no clue where else to look.

    I thought maybe a memory or space problem, but happens on other computers as well. Clean boot does not help. Repairing Database will run but does not correct.

    Any ideas ?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Tried creating a new database and importing all the objects into it?

    I don't know what error 32790 is, but you could be a little more specific, such as posting the line of code the compiler stops on when you get the error!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2002
    Posts
    108
    Quote Originally Posted by StarTrekker
    Tried creating a new database and importing all the objects into it?

    I don't know what error 32790 is, but you could be a little more specific, such as posting the line of code the compiler stops on when you get the error!
    Yes, I have tried that several different times by importing all, and then importing just the forms I was NOT working in when I received the 32790 in case it was the form I was working on.... still did not work. It seems that once I get the 32790, I must trash that whole copy, because it seems that none of the forms can be imported or either the compiler displays the error.

    As far as the code the compiler stops on...
    It not any certain code. When I run the compiler, it never has a change to start compiling, it just instantly pops the error box.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'd still like to know what error 32790 actually is before moving forwards, but in the absence of a quick answer......

    Have you tried /decompiling?

    You could also do the fix for corrupted VBA...

    - copy all the code to text files
    - trash all the code in the database by setting form and report Has Module? property to false and deleting all modules
    - import the objects into a new database
    - transfer the code from the text files back into the new database
    - compile, compact and repair

    Long job and really annoying, but it's saved me from total rewrites at least twice.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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