Can't edit Vb!

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

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"NAS" wrote:

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

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.
--
NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".


"Jerry Whittle" wrote:

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"NAS" wrote:

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

Since it can't hurt, try the decompile / re-compile trick.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"NAS" wrote:

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.
--
NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".


"Jerry Whittle" wrote:

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"NAS" wrote:

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