views:

61

answers:

1

Is it possible to have an ODBC connection to a MS Access 2007 database on Windows XP without having any other database engine (i.e. Microsoft.ACE.OLEDB.12.0) installed?

I am using the following connection string which works on Windows 7 but not on Windows XP. (There is only *.mdb option in Data Sources (ODBC) control panel in Windows XP and no *.accdb option is there but both exist on Windows 7.):

connectionString = "Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=|DataDirectory|Database1.accdb"