Hello All,
I've developed an application, that uses ACE OLEDB to access .accdb file. It works ok on XP (32 bit). When I try to put that on Windows 7 (64 bit) it fails to get the data from the database.
If I use Select * , It works on Windows 7 but if I use Select fieldname, it fails. I installed Access Redistributables for x64 but no help. This code works in 32 bit but fails on 64 bit. In complile option, I've set it to "Any Cpu".
Any help is greatly appreciated.

sOleDbConnectionString = "Provider=MSDataShape;Data Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " & oAppConfig.GetMetaFileNamePath & " ;"

strSQL = "SELECT field_name from EE_DDICT"

If MetafileConn Is Nothing Then
MetafileConn = New OleDbConnection(sOleDbConnectionString)
End If

Dim MetafileDA As OleDbDataAdapter = New OleDbDataAdapter(strSQL, MetafileConn)
MetafileDA.Fill(FieldsDS, "DataDict")