Problem with VBA and Access 2000

[Gregor Cleophas]

Hello community !

I have a strange problem with VBA and Access 2000 - it would be great, if
somebody could help me in this matter.
I wrote a program, that should access an EXCEL File via VBA as a DATABASE
under Acess 2000.
The program works fine on the PC where I wrote it. On any other machine
it stops with the runtime error: 3170 - "Installierbarer ISAM nicht
gefunden". [Sorry, that I wrote the error message in German - something
like : installable ISAM not found]
That is strange, because the other systems use the same configuration:
Win 2000, Access 2000 as the machine where the programm was written on.

The following selection where made in the VBA Script:
VB for applications
MS Access 9.0 Object Library
OLE Automation
MS DAO 3.51 Object Library

Help would be greatly appreciated !!

Gregor

 

[SA]

Gregor:

First, you should switch your DAO reference to 3.6, which is what Access
2000 uses to get to the Jet 4.0 engine which is part of Access 2000, rather
than DAO 3.51 which is for the Jet 3.5 engine (Access 97). That may have a
straight forward and immediate impact because the different Jet engines use
different XL ISAM dlls and if the other user's have never had Access 97 or
XL 97 installed on their machine they will NOT have the version of the XL
Isam that your code is calling. So switch to DAO 3.6.

Second, just because the other machines have Access 2000 installed in
general, does not mean that the XL isam was installed. The XL ISAM is a
potentially optional component.

Third, even if the ISAM was installed, from time to time (I haven't figured
out what causes it ever,) I've seen machines where the registry entries for
the XL isam get hosed and of course import export to XL will then fail.

The xl ISAM dll is msexcl40.dll; you can check the registry values under

HKLM\Software\Microsoft\Jet under both the Engines\4.0 and ISAM formats
sub keys.

HTH

 

[Gregor Cleophas]

Hi, Steve !

Thank you very much for your help.
After performing the steps you described, it worked perfectly.

Again, thank you very much !!

Gregor