I have read this Tutorial
http://www.phpfreaks.com/tutorials/61/0.php
Great tutorial, however I have some questions hoping for answers
Situation:
1 MS-Access db
Test machine has Apache 2.0 installed, but target machine has IIS
I am using ADODB Library to simplify DB Access
1.
I can successfully connect to LOCAL MS-Access DB
But then after I secured the DB (Migration.db + Secured.mdw)
so you need to access Secured.mdw to be able to login into Migration.db
Then they stop working.
I have tried DSN-less (both Access and JET) connections.
// $dsn1 = "ODBC;DSN=$driver1;DriverId=25;FIL=MS Access;Dbq=$dbq;SystemDB=$systemdb;Uid=$user1;Pwd=$password1;";
// $dsn1 = "Driver=$driver1;Dbq=$dbq;SystemDB=$systemdb;DriverId=25;FIL=MS Access;Uid=$user1;Pwd=$password1;";
// $dsn1 = "Driver=$driver1;Dbq=$dbq;SystemDB=$systemdb;Uid=$user1;Pwd=$password1;";
//$dsn1 = '"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='.$dbq.";Jet OLEDB:System Database=".$systemdb.';","Reader",""';
you'd think that adding SystemDB=secured.mdw would work, but obviously not.... now I'm struggling (I used the full path for the files too)
2.
I have read on PHP.net that ODBC has some weak points
http://www.php.net/manual/en/function.odbc-connect.php
1. It cannot access a Access database via a mapped drive. And this is for ANY application, name it PHP, Coldfusion, whatever
2. You cannot make a system DSN with a UNC (\Server\resource), so you must map the drive
So eventually my PHP needs to access the Access DB on the network, so I guess ODBC is not an option. Just need to confirm this......
3.
I thought of creating a local Access DB, with a linked Table to the network DB. I can double-click and open the table in Windows, but once I go through ODBC it says "I don't have enough permission" even to just "read". Any idea why?
So should I stay away from ODBC really, or are there some other ways?
I am surprised on unabling to find many articles on accessing secured MS-Access database from PHP thru Google.........
