Microsoft jet database engine could not find installable isam

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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
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: "

Rey Obrero (Capricorn1)Commented:
btw, how are you combining the two spreadsheets?
Rey Obrero (Capricorn1)Commented:
what version of Office were you using prior to upgrading to O2007?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

dovehelpdeskAuthor Commented:
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.
Rey Obrero (Capricorn1)Commented:
<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?
dovehelpdeskAuthor Commented:
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.
dovehelpdeskAuthor Commented:
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?
Rey Obrero (Capricorn1)Commented:
do you have the full version of Office 2007 or an upgrade version?
dovehelpdeskAuthor Commented:
I am installing the full version of Office 2007 enterprise
dovehelpdeskAuthor Commented:
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?
Rey Obrero (Capricorn1)Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dovehelpdeskAuthor Commented:
ok, here I go....
Jeffrey CoachmanMIS LiasonCommented:

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:
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


dovehelpdeskAuthor Commented:
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!!!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.