Hello,
I have a program that reads data from an Access file. Initially, I was using the Microsoft Access driver in the ODBC library but the amount of data that I need to get from the .mdb file is too much for this useless driver to handle. So I switched to ADO using the following code:
$conn = new COM('ADODB.Connection') or die('Cannot start ADO');
$conn->Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=$mdbFilename; Persist Security Info=False;");
...etc
This code works perfectly,but the problem is that when I switched to this new library, the programs take longer to run probably because this driver doesn't run as fast as the odbc driver for access (???) I would like to know if there is another library/driver that I can use to open an Access file, or could I change the 'Provider' field in the connection string to something that will run faster?
Thank you in advance