desperatley seeking MVP Help

[Lisa]

Hi.

I have been having problems since I switched from Macros
to Code - I have been using the Smith/Sussman Beginning
Access 2000 VBA Book.

When I open the VBE Editor window, my system resources go
down to 15% or so!!!!!

I've decompiled, compacted, etc.

My forms with code attached open very slowly compared to
forms without.

My database is secured and is split. Note: I don't see
the relationships in my front end dbase though, only in
the back end. I ended up linking to the tables cause I
wanted a password on the backend, and I lost my
relationships in the front end....is this a problem?

Any ideas what could be wrong?

I am also running Access 97 and 2000 on the same computer.

Thanks
Lisa

 

[Albert D. Kallal]

"Lisa" <[email protected]>

wrote in message

My forms with code attached open very slowly compared to
forms without.

I would turn off track name auto correct. In fact, check out the following
list of performance got ya's.

http://www.granite.ab.ca/access/performancefaq.htm

My database is secured and is split. Note: I don't see
the relationships in my front end dbase though, only in
the back end. I ended up linking to the tables cause I
wanted a password on the backend, and I lost my
relationships in the front end....is this a problem?

The relationships are ALWAYS set in the file where the data is, so, no, the
above is not a problem. Since the data is in the back end, then that is
where you set the relationships.

 

[Lisa]

Albert
Thank you for that wealth of helpful tips and
information. I've made the necessary adjustments
including a proper decompile from the start menu and my
database is purrin like a kitten.

Lisa