problem in Access 2000 with forms

[Hugo Lefebvre]

I develop databases for years in microsoft access. From time to time I have
the same problem in Access2000: if I open a form in a .mdb database, the
database closes inexpectly. Sometimes I can open the same form and sometimes
not. Once the problem occurs in a database, nearly each form can give
problems. The problem occurs with great databases, with many forms and with
really great forms: many objects and many code in vba. I use dao 3.6 object
library.

If a compile the database to a .mde-file, then there is no more problem.
Problem is that I cannot do a mailmerge with Word from a .mde database in
Access2000 (no problem in Access2003).

If I open the Access2000 database in Access2003: no problem. Problem is that
the the database is used by persons using Access2000.

So I have two questions:
How can I resolve the 'form'-problem in Access2000 mdb-files?
How can I resolve the mailmerge problem in Access2000 mde-files?

Can anyone help?

 

[Lisab]

These are the only things I could think of to maybe prevent the problem in
the future.

1. make sure you Compile everytime code is added or edited (found in the VB
code window in Debut -> Compile)
2. anytime you import a form or report (especially those with code) make
sure the first thing you do after importing is go to the code window and
Compile
3. uss the Compact & Repair option in Tools ->Database Utilities

 

[Lisab]

Also look here

http://allenbrowne.com/ser-25.html