Can't edit Vb!

[NAS]

Whenever I try to edit the Visual Basic in my database, I get an error saying
"Unexpected error, quitting" followed by an alert saying "Out of memory".
What do I need to do to fix this issue? I am using Access 2003 on Windows XP.
--

 

[Jerry Whittle]

1. Make a complete backup of the database file and put it away for safe
keeping.

2. Run a Compact and Repair (but it probably won't help).

3. In the VBA window go up to Debug, Compile? What happens when you run it?

4. If 3 doesn't help or work right, create a new database and try to import
everything into it. If something won't import, it's probably corrupted beyond
help.

5. Do a google search of the "access decompile". This can often clear up
code problems.

 

[NAS]

Luckily its a copy and the orignal database doesnt seem to have any issues.
I'm not sure if maybe this is the cause of the problem. I ran a compact and
repair but like you said, it didn't help. Unfortunetly I can'tget to the VBA
window to debug it. I click on Visual Basic Editor and nothing happens.

 

[Jerry Whittle]

Since it can't hurt, try the decompile / re-compile trick.