Access 2002 and 2003 compability problem

[wongcna]

Hi All,

My small company has a database which are based on 2 files:

1. the actual database in "database.mdb"
2. the user interface contain the VB codes and forms "report.mdb"

The database works well on Access 2002 but Access 2003 does not like it, an
error dialog box pop up and ask me to send detail to microsoft..I tried to
convert the "report.mdb" to 2002 - 2003 File Format, then Access 2003 can
open it but Access 2002 cannot open it and come up with an error dialog box
to ask me to send detail to microsoft.

I cannot find the error log file or error description.


Please help


Much thanks


wongcna

 

[Sylvain Lafontaine]

The forms and reports inside the database file Report.mdb must be compiled
by Access before they can be opened and this compilation if version
dependant, not only for Access 2002 or 2003 but also for other things in the
user machine, like the latest SP for the Windows operating system.

Each of your users should have its own personal copy of the report.mdb file.
This is a very important thing. Look for the /decompile switch to remove
the compiled modules from a previously opened file. An easier way is simply
to add a new (but otherwise unused) reference in the References dialog
window of VBA (and remove it the next time); as this will force Access to
recompile every modules.

Look at the article
http://support.microsoft.com/default.aspx?scid=kb;en-us;323203 for a way of
automating this step. (Caution: the source code in this article has a small
bug: remove the "Exit For" line from the code, otherwise the order of the
references way change. This order may or may not be of particuler
importance for your code.

S. L.

 

[Guest]

I would like to express my thanks to Sylvain Lafontaine.

Much appreciate!

wongcna