settin references to lib

  • Thread starter Thread starter Jose Pineda
  • Start date Start date
J

Jose Pineda

I have some users who inherited many Access 97 db's from a
developer who is no longer available. The users would
like to upgrade to Office 2002. The concern is having to
manually set the reference to the 3.5 DAO lib in each db.
Is there any way to configure Access 2002 to reference any
of the older libraries whenever the app is launched? In
other words, a global setting for Access 2002 to set
references other then the default ones?
 
. . . inherited many Access 97 db's . . .
The users would like to upgrade to
Office 2002. The concern is having to
manually set the reference to the 3.5
DAO lib in each db. Is there any way
to configure Access 2002 to reference
any of the older libraries whenever the
app is launched? In other words, a
global setting for Access 2002 to set
references other then the default ones?
Click to expand...

DAO 3.5 is for use with Jet 3.x, used with Access 97. Access 2000 and later
use Jet 4.x, which requires DAO 3.6. Access 2002, by default, doesn't
reference DAO at all, but does reference ADO. Not only do you need to set
the reference to DAO 3.6, you also need to either (1) be sure to qualify all
uses of shared object-types with DAO. (as in Dim rs as DAO.Recordset), (2)
move the DAO referend higher than the ADO reference in the References list,
or (3) uncheck the reference to ADO, if you don't use it.

I am sure there is VBA code for manipulating references, but I have not used
it. Perhaps someone who has can tell you how some of the changes could be
automated.

Larry Linson
Microsoft Access MVP
 
You won't have to manually set the DAO reference...it gets changed
automatically when you convert the database. If the database has any other
references though, that is another matter. If they just have the default
references, converting is easy.
 
Back
Top