It involves accessing two databases. One Local Microsoft Access and
one networked VisualFoxPro. The latter is connected via ODBC. The VB
program connects to the Access database if the network connection is
not available and works OK. But it crashes with an "Application
defined or object
defined error" if there is a network connection when it tries to
access the visual foxpro database. Error trapping tells me that the
crash occurswhen it reaches the second line of this piece of code.

Dim DataEnvironment As New DataEnvironment

With DataEnvironment
.connLocal.Open
.connNetwork Open

The connection to the newtork database works OK on my development
machine and on two other PCs I have managed to successfully installit
on so I am assumming it must be correct.
.connLocal is the local Access database (this part works OK on the
windows
2000 machines)
.connNetwork is the network VisualFoxPro database (I have checked the
ODBC
connection this is based on and this works OK on all the machines i
have
installed it on but only when I use it directly from Access)

I have tried the following:

Using different versions of MDAC_TYP to check that there isn't any
incompatablility
Checking that Microsoft Data Environment Instance 1 (SP4) is
installed. It
didn't pick this up automatically for some reason. Is this all I need?
Installing VB6 on the machine. (This worked in one case but not the
others?
Perhaps something odd about the sequence of things I have tried)

Are there any other references that I should have in VB when I compile
the
program?

I have got it to work on two Windows 2000 machines ( the ones I
normally use
at work) but I can't get it to install on any others.

If anyone has any suggestions they would be very much appreciated.

Jonathan Smith

You may consider using the Installshield, which has all the libraries in it
for smoothly running your program on other machines. It is the best for
making installations.

Ps..You can try installing a copy of the Visual Basic on the client
computer, this will surely solve the problem ;)

Best Regards,

Robert.