Conversion Problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a two-part question to anyone kind enough to answer. We just upgraded
from Access 97 to 2003. When converting my 97 FE and BE database to 2003 I
get the following message: "After you have converted this file to Access
2000 File Format, the new file cannot be shared with Access 97 users." It
goes on to say, "Any functionality specific to Access 2002 or later will not
be available in Access 2000." I don't understand... why am I getting this
message when I'm converting to 2003, not to 2000?

Question #2... When convertig my 97 BE to 2003, I receive the following
error message: "Missing or broken VBE reference to the file 'dao2535.tlb'."
What is this and is it something a novice like myself should be able to fix?
The database seems to be operating fine, so far, without doing anything to
fix it.
 
Hi Kat,

Well, the newly converted file cannot be shared with A97 users because
of the changes in object libraries between A97 and all later versions.
The programmers of 1997 (well, 95-96) couldn't "see into the future," so
to speak. To put it another way, newer versions can open/convert
databases created using older versions; but once a database has been
converted to the newer version, it cannot easily be read by the older
version. A2K, A2K2, and A2K3 have most of the necessary object
libraries available to them (although sometimes you have to enable
them). The second message refers to the same situation.

To fix missing references to particular object libraries, open any
module in Design View, then select Tools > References. If any libraries
are marked as MISSING, then uncheck them (i.e. clear the check boxes).
If this doesn't take care of the problem, or if no libraries are flagged
as "MISSING," then see my reply upthread to Liz's question "Reference to
Library not working" for some tips on how to troubleshoot missing/broken
references when converting.

hth,

LeAnne
 
Thank you LeAnne. I'm trying to understand but, I'm just
not getting this. I do understand that the newly converted
file cannot be shared with A97 users but, if I'm running
A2K3 now and I open a database created in A97 and convert,
shouldn't it convert to A2K3... not A2K? If it converts
to A2K instead of to A2K3, won't I continue to suffer
compatibility issues since "...any functionality specific
to Access 2002 or later will not be available..." in the
A2K file I just converted to?
 
The default format for Access 2003 (and Access 2002, for that matter) is the
Access 2000 format. If you want to use a newer format, you can convert the
database to the newer format under Tools | Database Utilties. You can also
change the default format in both versions.
 
Thank you Doug... I do have a much better understanding now. What is the
reasoning behind the default format for Access 2003 being the Access 2000
format? Since my computer is running 2003, wouldn't it be better to convert
to the 2002-2003 format?
 
It's often hard to discern Microsoft's motives <g>, but I'm assuming it was
kept at Access 2000 level to maximize interoperability. If you're using the
Access 2000 format, users with Access 2000, Access 2002 or Access 2003 can
use it without any issue. If you convert to a newer format, fewer users can
use it.
 
Remove the reference to dao2535.tlb. That's a really old type library that
stopped working after Access 97 (it was there to ensure backwards
compatibility when you converted an Access 2.0 database to Access 97)

As long as you have a reference set to Microsoft DAO 3.6 Object Library, you
should be okay.
 
MY NAME IS LAURA AND I'M HAVING PROBLEMS WITH CONVERTING MY COMPUTER OVER TO
MICROSOFT OFFICE 2003. I JUST PURCHASE THIS COMPUTER AND MY 90 DAYS TRAIL IS
OVER. SO NOW I NEED TO HAVE A VALID PRODUCT KEY TO CONVERT OVER. COMPAQ TOLD
ME TO INFORM YOU ALL SO YOU CAN FIX THE PROBLEM.
 
I NEED A VALID PRODUCT KEY TO CONVERT MY SYSTEM OVER BECAUSE MY 90 DAYS TRAIL
IS OVER. THIS IS A NEW COMPUTER.
 
Laura, this is a public forum where private individuals answer posted
questions re using MS Access database software. suggest you contact
Microsoft directly via their website www.microsoft.com
btw, when posting anywhere on the web, suggest you do not use all caps for
the entire message - that is generally considered to be the same as
SHOUTING.

hth
 
Back
Top