Solved

Excel 2010 Could not find installable ISAM

Posted on 2013-05-15
6
847 Views
Last Modified: 2013-05-16
Hi All,

I have an excel workbook which pulls in data from multiple access databases.

The document was created on my laptop and has worked for 8+months however I am now unable to refresh the data from access and get an "Could not find installable ISAM" error.

The document can be opened on other computers and runs without issue so its not a problem with the connection string, I also have full access to the files (direct through access).

Excel is v 2010 32 bit running on Win 7 x64 - I recently ran windows update so Im not sure if something in there may have broken it and I have tried a detect and repair on office with no luck.

Any ideas other than format/reinstall?

Thankyou
Paul
0
Comment
Question by:bentbris
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39169967
Hi,

Please can you quote the Connection String you are using?

Thanks.

BFN,

fp.
0
 

Author Comment

by:bentbris
ID: 39170019
ConnString is (the .xpa file extension is a renamed mdb used for an accounting package).

As mentioned both machines use the same connection string but the other doesn't have the issue - Forgot to mention that other machine is win xp with office 2010 32 bit.

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=U:\AUDIT.XPA;Mode=Read;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False
0
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
ID: 39170429
Thanks.

Presumably the renaming of the MDB file to one with a ".XPA" extension has remained constant throughout the 8+ months you mentioned.

Have you reviewed the list of updates within the recent Windows Update?

This can be found using the Windows Control Panel:

[ Control Panel\All Control Panel Items\Windows Update\View update history ]

Do any of the provided descriptions give details of updates to database connectivity?


Also, have you tried using Windows Restore (if you have it enabled/running) to rollback your machine with the issue to a point before the Windows Update took place to prove that it is something within the list of updates that is producing the error?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:bentbris
ID: 39173320
Looking at that today (windows updates) and Ive discovered that my 2010 office does not have SP1 installed so I will check that too (just incase).

Yes the file extension has remained constant.
0
 

Author Closing Comment

by:bentbris
ID: 39173556
Thankyou - Rollback of windows update has fixed my issue - ill ensure office is up to date and try the windows update again when I have time.

Thankyou
Paul
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39173876
You're welcome, Paul.

Hopefully you can establish which of the elements of the latest Windows Update caused the issue & just elect to remove that from the list on the next occasion.

Good luck!

BFN,

fp.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel for Mac - How make those Tabs larger? 2 31
Freeze Panes Solution 6 28
ActiveX Listbox Multi Select in Excel 2010 8 16
Auto Adjust Percent rate 5 14
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

929 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

9 Experts available now in Live!

Get 1:1 Help Now