?
Solved

Could not find installable ISAM.

Posted on 2014-08-25
4
Medium Priority
?
436 Views
Last Modified: 2014-08-27
When trying to connect to an MS Access 2010 database file using VB.NET I am getting the error:
"Could not find installable ISAM"

I'm using the following:
Window 7 Pro 64bit
Visual Studio 2013
MS Access 2010 database file
Connection String = "Provider=Microsoft.ACE.OLEDB.12.0; DataSource=/Resources/offLineTags.accdb; Persist Security Info=False;)"

I have installed the 2007 Office System Driver: Data Connectivity Components but still get the same error

Thoughts?
0
Comment
Question by:BrianFord
  • 2
  • 2
4 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1500 total points
ID: 40283560
Use back slashes instead of slashes for the DataSource argument.   See if that works.

Jim.
0
 

Author Comment

by:BrianFord
ID: 40283960
unfortunately, same error
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 1500 total points
ID: 40283988
OK.   Most common cause then is just what the error message says; it doesn't have the isam component it needs.

To get that, download and install this:

Microsoft Access Database Engine 2010 Redistributable
http://www.microsoft.com/en-us/download/details.aspx?id=13255

Jim.
0
 

Author Closing Comment

by:BrianFord
ID: 40288009
I tried that but it wouldn't install.

if I run the 32bit version it says I can't because I have 64 bit Office installed, if I run the 64Bit version it says I can't because I have 32 Bit Office installed. I definitely have 64Bit install of Office.

At this stage I'm not going to fight this any longer, I have decided to use a local text file for the temp storage I need as I'm running out of time to get this solution in place

Thank you both for trying to help
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

862 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