Save As 02-03

[ainow]

When saving a 07 database to 02-03 the mdb NEVER compiles – Reference must be
rearranged to correct. Is there something I am missing when I save it?

 

[Allen Browne]

What do you mean by, "the mdb NEVER compiles"?

Do you mean that after you create the MDB, and then open it in an earlier
version of Access, you get errors when you try to compile? Is that where you
must sort the References out?

What references are you using? In general, Access sorts out the Access and
Office references when you change version, but you may find that other
references (such as the Calendar control or graph) must be changed manually.
This is one of the reasons why many of us eschew references beyond the basic
ones:
http://allenbrowne.com/ser-38.html

 

[ainow]

It will not compile in either 07 or 02-03. After converting and it opens the
mdb, it opens with a “Compile error : Method or data member not foundâ€. The
error cannot be corrected until the mdb is closed and reopened in design
mode. Moving “Microsoft DOC 3.6 Object Library†up to just after “Microsoft
Access 12 Object Library†will correct the problem.

 

[Allen Browne]

If the application compiles okay without the DAO library, perhaps you could
correct the problem by removing that reference before you save it as the old
version.

 

[ainow]

If the DAO library reference is unchecked, it will not compile.

Let me rephrase the question. Is it possible to convert a 07 project to a
02-03 without having to go through the process described in the 2nd
11/24/2007 question?

In addition, if I open a (converted from 07) mdb and make a mde it will not
run on a 02-03 computer (This database is in an unrecognized format.). To
make this work I must build the mde from the mdb using 02-03. Is the normal
are is there something I should be doing different?


:

If the application compiles okay without the DAO library, perhaps you could
correct the problem by removing that reference before you save it as the old
version.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

It will not compile in either 07 or 02-03. After converting and it opens
the mdb, it opens with a “Compile error : Method or data member not foundâ€.
The error cannot be corrected until the mdb is closed and reopened in design
mode. Moving “Microsoft DOC 3.6 Object Library†up to just after
“Microsoft Access 12 Object Library†will correct the problem.

 

[Allen Browne]

Every version uses a different binary. Code compiled in one version of
Access cannot be read in an earlier version, but it can be read in a later
version. That means you always must compile in the oldest version that will
be using this database.

So, yes: it's quite normal that Access 2002 or 2003 will not be able to read
the compiled code from A2007. If it's an MDB that's been compiled in A2007,
Access will (transparently) recompile it into the older binary when you open
it in A2002 or 2003. That can't happen with an MDE.

The same problem arose with a file in A2002/3 format. If you compiled it
into an MDE in A2003, you could not use it under Access 2002.