Access 2013 && Delphi 2007

[wisdom]

Hi, everyone. I'm trying to force Access 2013 x64 to interoperate with Delphi 2007 (32-bit application) .
I'm using ADOConnection with .udl file.
Connection string is:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.ACE.OLEDB.15.0;Data Source=E:\StaffDepartment\db_files\StaffDatabase.accdb;Persist Security Info=False

There're such ODBC drivers in my system:
1) Microsoft Access dBase Driver (*.dbf, *.ndx , *.mdx)
2) MIcrosoft Access Driver (*.mdb, .accdb)
3) Microsoft Access Text (*.txt, *.csv)
4) Microsoft Excel Driver (*severel excel extensions*)
5) SQL Server
Everytime i try to activate connection (AdoConnection.Connected:= true) i get "Provider cannot be found. It may not be properly installed".
I tried to install Microsoft Access Database Engine 2010 Redistributable in conjuction with Microsoft.ACE.OLEDB.12.0 . But it didn't help.
What else can I do ?
Any help would be most welcome.

 

[wisdom]

So I had to use virtual machine with Office x32 and Windows x32. And all have been good so far.

But now, another issue's appearing. Why does this query raise Syntax error:

select * from [my_table] where
[DateBirth] >= #01.01.1980#

The "DateBirth" field has date/time type. Format of date/time data in this field is 'dd.mm.yyyy'
I'm novice at Access, and don't understand why did this error occur.

 

[CJ_London]

Try

[DateBirth] >= #01/01/1980#

When using # then date structure should be american format i.e. 1st June 2013 would be 06/01/2013

 

[wisdom]

CJ London, you're right, thanks for explanation.