Solved

Microsoft jet database engine could not find installable isam

Posted on 2010-08-19
14
787 Views
Last Modified: 2012-06-27
I am running a program that combines two spreadsheets into an Access database.  Since I upgraded to Win 2007 it has not worked giving me the error "microsoft jet database engine could not find installable isam".  I uninstalled and reinstalled Office 2007 Enterprise and still get the same error.  Can you help?  -Barbara
0
Comment
Question by:dovehelpdesk
  • 7
  • 6
14 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
are you uninstalling the Office 2007 from the Control Panel > add remove program?
then rebooting the machine before Installation
On installation, do a complete install ( run everything on the computer )

"ISAM drivers are used by Access to update file formats other than its own. If the path to the ISAM driver in your Windows registry is not valid, or if the ISAM driver does not exist, you may receive one of the following error messages: "

from http://support.microsoft.com/kb/283881/
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
btw, how are you combining the two spreadsheets?
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
what version of Office were you using prior to upgrading to O2007?
0
 

Author Comment

by:dovehelpdesk
Comment Utility
I was using Office 2003 and the program worked fine.  when I uninstalled 2007 and reinstalled it, I used the uninstall from the installation disk.  I went to the website capricorn sent and I can't find the files they list, so I reinstalled office 2007 and still can't find the files.
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
<I used the uninstall from the installation disk.>
I will try using the Control Panel > Add or Remove Programs to uninstall the Office,
then reboot the machine, before doing the Installation as i mentioned above.

do you have the full version of Office 2007 or an upgrade version?
0
 

Author Comment

by:dovehelpdesk
Comment Utility
I uninstalled Office 2007 using the uninstall from control panel, then reinstalled it and did all the updates.  I then went to the registry to see whre it thought Msexcl40.dll was and it is in the right place.  It's the hotkey listed as win32old.  Above it was a key called win32  wehre it geve the address c:\program files\microsoft office\OFFICE11\msaexp3.dll.  I checked that address and found the file in c:\program files\microsoft office\OFFICE12, so I edited that key.  I then ran my program and got the same ISAM error, so I ran Regsvr32 c:\winnt\system32\msexcl40.dll and it said it registered msexcl40.dll.  Now I get a different error.  Microsoft JET Database Engine No value given for one or more required parameters.  I've attached a screen capture of this error.
new-error.JPG
0
 

Author Comment

by:dovehelpdesk
Comment Utility
I have the following in the registry
win32 c:\Program Files\Microsoft Office\OFFICE11\msaexp3.dll
win32old C:\WINDOWS\system32\msexcl40.dll

I looked for c:\Program Files\Microsoft Office\OFFICE11\msaexp3.dll and can't find the directory office11.  I have a directory office12.  So i edited the entry, but still get the same error.

I asked someone what they have in their registry, and they don't have
c:\Program Files\Microsoft Office\OFFICE11\msaexp3.dll
So I removed that and moved C:\WINDOWS\system32\msexcl40.dll to win32.  this is what htey have in thier registry and they can run the program I can't.
But I get the same error.
I'm sure if I reinstall office2003 it will work.  Can I run both?
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
do you have the full version of Office 2007 or an upgrade version?
0
 

Author Comment

by:dovehelpdesk
Comment Utility
I am installing the full version of Office 2007 enterprise
0
 

Author Comment

by:dovehelpdesk
Comment Utility
I was thinking of instaling Office 2003 again. I used to have 2003 and 2007 on this machine.  the problems started after I removed Office 2003.  I was thinking I'd remove 2007 again, then install 2003 then install 2007 over that.  Do you think that will work?
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
this maybe a pain, but, if you are not sure how to edit the registry properly,

* unistall Office 2007 ( i will repeat, use Control Panel > Add remove Program )
* reboot computer
* Install Office 2003
* reboot computer

   At this part, test your application again to see if it will work properly..

If it is working properly, UNINSTALL Office 2003  ( i will repeat, use Control Panel > Add remove Program )

* reboot computer

* Install Complete Office 2007






0
 

Author Comment

by:dovehelpdesk
Comment Utility
ok, here I go....
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
FWIW,

ISAM, stands for: (I)ndexed (S)equential (A)cess (M)ethod.


What OS are you running?

Also make sure that you are up to date with all your service packs for Windows and Office.

Here is a fix for this error from the web:
http://it.toolbox.com/blogs/sharepoint-blog/could-not-find-installable-isam-17062
Basically in this code:
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\metadata.xls;Extended Properties=Excel 12.0";
...replacing:  Excel 12.0
...with:  Excel 8.0
...fixed the issue

;-)

JeffCoachman
0
 

Author Closing Comment

by:dovehelpdesk
Comment Utility
I followed the directions exactly, and I can now run my report program.  I think I had corrupted my installation of office by not removing the prior version correctly.

Thank you!!!!
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now