R
Russ
Anybody have an explanation for this one?
Simply put I have a small network (6 machines) and two
servers.
Each of the machines are running XP Pro.
All of the machines WERE running Office 97.
I have a MS Access Datbase on one of the servers. It has
been converted from '97 to 2K.
On 5 of the network machines I uninstalled '97 and
installed Office 2k Premium. Each of these machines can
open the database with no problems. (well sometmimes
there's a .ldb that get's in the way but that's another
issue)
The problem I am having is that machine #6, when it tries
to open the database it gets clobbered when it tries to
execute the Visual Basic code. It says it cant find an
object library.
Ok, so I go into references and it says
MISSING Microsoft DAO 3.5 Object Library (NONE OF THE
OTHER MACHINES DID THIS - but I have seen this problem
before (another place; another time).
I scroll down looking for the 3.5 refrence and I found
instead:
Microsoft DAO 2.3/3.5 Compatibility Library
Microsoft DAO 3.0 Object Library
Microsoft DAO 3.51 Object Library
Guess which one worked....
NONE OF THEM.
I tried several times. with all of them, changing the
priority positions, deselecting, selecting etc.
When the 3.0 was selected it immediatly said it had an
error loading DLL the other two waited until I tried to
compile the source code before it said it had an error
loading the DLL.
The (I just checked) other machines have Microsoft DAO
3.6 Object libraries installed in their references.
The question is WHY?
All of the machines are identical HP machines and the
Office installation software was the same for all.
---
"If the software doesn't work then I suggest that you
call the support team... I'm a developer"
Many thanks in advance,
RJ
Simply put I have a small network (6 machines) and two
servers.
Each of the machines are running XP Pro.
All of the machines WERE running Office 97.
I have a MS Access Datbase on one of the servers. It has
been converted from '97 to 2K.
On 5 of the network machines I uninstalled '97 and
installed Office 2k Premium. Each of these machines can
open the database with no problems. (well sometmimes
there's a .ldb that get's in the way but that's another
issue)
The problem I am having is that machine #6, when it tries
to open the database it gets clobbered when it tries to
execute the Visual Basic code. It says it cant find an
object library.
Ok, so I go into references and it says
MISSING Microsoft DAO 3.5 Object Library (NONE OF THE
OTHER MACHINES DID THIS - but I have seen this problem
before (another place; another time).
I scroll down looking for the 3.5 refrence and I found
instead:
Microsoft DAO 2.3/3.5 Compatibility Library
Microsoft DAO 3.0 Object Library
Microsoft DAO 3.51 Object Library
Guess which one worked....
NONE OF THEM.
I tried several times. with all of them, changing the
priority positions, deselecting, selecting etc.
When the 3.0 was selected it immediatly said it had an
error loading DLL the other two waited until I tried to
compile the source code before it said it had an error
loading the DLL.
The (I just checked) other machines have Microsoft DAO
3.6 Object libraries installed in their references.
The question is WHY?
All of the machines are identical HP machines and the
Office installation software was the same for all.
---
"If the software doesn't work then I suggest that you
call the support team... I'm a developer"
Many thanks in advance,
RJ