could I have a virus in my code?

[Lisa]

Hi.

I have compacted and decompiled my database. Things
seemed to be OK, but now whenever I go into the vbe editor
window my system resources are going down to 6% or
less....sometimes I can't even get into the properties of
My Computer to see how much I have left. And sometimes I
can't get into the vbe editor window directly from a form.

I am running Access 2000 on Windows 98. I have 256 mb of
ram.

Could a virus have gotten into my code? I have scanned it
with AVG but it says it's OK.

The total file size is 4.5 mb.

Please help
Thanks
Lisa

 

[Dirk Goldgar]

Hi.

I have compacted and decompiled my database. Things
seemed to be OK, but now whenever I go into the vbe editor
window my system resources are going down to 6% or
less....sometimes I can't even get into the properties of
My Computer to see how much I have left. And sometimes I
can't get into the vbe editor window directly from a form.

I am running Access 2000 on Windows 98. I have 256 mb of
ram.

Could a virus have gotten into my code? I have scanned it
with AVG but it says it's OK.

The total file size is 4.5 mb.

Please help
Thanks
Lisa

Do you have a whole lot of code windows open at once in the VB Editor?
Each of those windows uses resources, I think. Try closing them all and
saving your project while in that state.

 

[Lisa]

Hi again.

Yes, I have code on 41 forms, 16 reports, and 9
modules...is this too many?

Is there a way to set the vb editor window to NOT open
them all every time I go in there?

Thanks
Lisa

 

[Lisa]

oops, think I was suppose to reply here.

When I close some of the windows in the vb editor, my
system resources does go back up. If I just close the vb
editor all together, the system resources stay at the low
value and I have to close Access altogether to get them to
come back up and then I can go in again.

Anyway. I have code on 41 forms, 16 reports, and 9
modules. Is this too many?

Can I set the vb editor to NOT open all of the windows
every time I go in there?

Thanks
Lisa

 

[Dirk Goldgar]

oops, think I was suppose to reply here.

Right you are.

When I close some of the windows in the vb editor, my
system resources does go back up. If I just close the vb
editor all together, the system resources stay at the low
value and I have to close Access altogether to get them to
come back up and then I can go in again.

I don't really know why this is, but I guess the windows are still open,
but hidden, until you close Access entirely.

Anyway. I have code on 41 forms, 16 reports, and 9
modules. Is this too many?

It's not the number of modules you have, it's the number you have open
as windows in the VB Editor.

Can I set the vb editor to NOT open all of the windows
every time I go in there?

Did you do what I said: close each individual module window, then click
the Save button (or the File -> Save <project> menu item) to save your
VB project in that state? It works for me. The problem, I think, is
that you've never closed these windows.

 

[Lisa]

Hi.
Oh...I did do what you said but I didn't notice that the
windows were staying closed....because not all of them
stay closed, there's about 5 from various forms or reports
that are open when I go back in.

Any ideas on that?

Thanks for all of your help
Lisa

 

[John Vinson]

Anyway. I have code on 41 forms, 16 reports, and 9
modules. Is this too many?

No; but it would be if you have them all open for editing at the same
time.

Can I set the vb editor to NOT open all of the windows
every time I go in there?

Close each window when you're done with it, after saving the
form/report/module which you were editing; Access won't (shouldn't
anyway!) open it back up until you ask for it.

 

[Dirk Goldgar]

Hi.
Oh...I did do what you said but I didn't notice that the
windows were staying closed....because not all of them
stay closed, there's about 5 from various forms or reports
that are open when I go back in.

Any ideas on that?

Sometimes you have to let the editor know that it really does need to
save the project. Modify a line in one of those modules by simply
typing a space at the end of a line. Then close all the open windows,
then click the Save button, and then close the application. When you go
back in, you should find that all the module windows in the VB Editor
are closed. Let me know if this doesn't work.