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.
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.
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.