Hi.
I hate to recommend installing MS Office XP SP-3 because of the problems it
caused for Access, but this is one of the issues that this service pack
fixed. The binaries for Access 2002 and 2003 are different enough that
saving the database in Access 2003 *.MDB format even one time, then opening
it in Access 2002 and converting it to Access 2002 *.MDE format will make the
Access 2002 *.MDE database file incompatible with Access 2002.
Before installing MS Office XP SP-3 on the Access 2002 computer though, I
would try to create a new Access 2002 *.MDB database file, import all objects
from the original Access 2002 *.MDB database file, compile the code, then
create a new Access 2002 *.MDE database file and see whether this new *.MDE
database file runs in Access 2002. The Access 2003 computers should have no
problem running either of the Access 2002 versions of the *.MDE database file.
And if that didn't work, I'd try the Access 2000 database format (even
though it doesn't have a few of the nifty features of the later versions).
And if that didn't work, I'd seriously consider purchasing and installing MS
Office 2003 for the MS Office XP computer. And if that option didn't get
approved, I'd tell the MS Office XP user, "Sorry. This *.MDE database file
run won't run with Access 2002."
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.