Unable to compile Access 2000 mdb from Access 2003.

[jlsunny]

Access 2003 does not show the Object 9.0 reference libraries needed to
recompile as an Access 2000 database. When using Access 2002, 'debug-compile'
prompts the user with an option to compile in Access 2000. All features of
Access 2003 have been installed, but this option doesn't appear. Only 11.0
object files show in the reference list. Any ideas what the problem could be?

 

['69 Camaro]

Hi.

Access 2003 does not show the Object 9.0 reference libraries needed to
recompile as an Access 2000 database.

Only 11.0
object files show in the reference list.

As it should be. One shouldn't have multiple versions of the default Access
libraries referenced in the same database file. (And one needs to be
careful with referencing multiple versions of other libraries, as well.) It
can cause incompatibility problems, especially if Access 2K doesn't have
Office 2K SP-3 installed. And even if it didn't have library
incompatibility problems, your application might not run on a computer that
didn't have _all_ referenced versions installed.

Access 2K is the default file format for both Access XP and Access 2003, so
it's possible to develop an Access 2K application in Access XP or Access '03
and have the Access 2K users be able to run the application, as long as the
application doesn't use any Access XP or '03 capabilities.

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.)

Access 2003 does not show the Object 9.0 reference libraries needed to
recompile as an Access 2000 database. When using Access 2002, 'debug-compile'
prompts the user with an option to compile in Access 2000. All features of
Access 2003 have been installed, but this option doesn't appear. Only 11.0
object files show in the reference list. Any ideas what the problem could

be?

 

[jlsunny]

Thank you for replying. I am aware of the Access 2k
default file format. I don't understand why I can't
compile and run my Acess 2000 program in Access 2003. It
recompiled and runs in Access 2002 without a glitch. The
literature says it should be just as easy to recompile and
run in A2003, but it won't compile, it provides no option
to compile as 2000 database, and the reference libraries
are not available. Why is the option to compile in 2000
format not available in A2003, as it is in A2002?
Thanks.