desperatley seeking MVP Help

  • Thread starter Thread starter Lisa
  • Start date Start date
L

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
 
"Lisa" <[email protected]>

wrote in message
My forms with code attached open very slowly compared to
forms without.
Click to expand...

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?
Click to expand...

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