Could not find installable ISAM.

[EDN Admin]

Let me preface this by saying I am a complete newbie to database programing.
I am writing a program that has to be compiled as AnyCPU. I found out that I could not connect to Access unless I compiled as X86. I then found the 2010 64 bit redistributable here http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en.
The guy I was writing the program for decided to buy a copy of 64 bit 2010, and I was setting up a new Win 7 64 bit computer so I installed the 2010 redistributable before installing my office 2007. I read somewhere that this should be OK, But I have
not been able to get it to work.
I presume it is Microsoft ActiveX Data Objects 6.0 Library that I should reference now?

<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; Public cn <span style="color:Blue; As <span style="color:Blue; New ADODB.Connection

<span style="color:Blue; With cn
.Provider = <span style="color:#A31515; "Microsoft.ACE.OLEDB.12.0"
.ConnectionString = <span style="color:#A31515; "DataSource = catabaseBatchPlot.accdb" & <span style="color:#A31515; ";Persist Security Info=False"
.CursorLocation = ADODB.CursorLocationEnum.adUseClient
.Mode = ADODB.ConnectModeEnum.adModeReadWrite
<span style="color:Blue; Try
.Open()

<span style="color:Blue; Catch ex <span style="color:Blue; As Exception
<span style="color:Blue; Stop
<span style="color:Blue; End <span style="color:Blue; Try

<span style="color:Blue; End <span style="color:Blue; With


[/code]
Some additional info.
My office version does not include Access.
The accdb file I am trying to connect to was created in 2007
On my old computer I could get this to work with the reference set to ActiveX 2.8 and the compile set to X86
Any guidence appreciated.






View the full article