PHP Access Problem

  • Thread starter Thread starter David Leppek
  • Start date Start date
D

David Leppek

Can anyone help me not lock my DB everytime I open this
page?
$db = 'D:\\hosting\\Site\\db\\Access_db.mdb';
$conn = new COM("ADODB.Connection")
or die("Cannot start ADO");
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=$db");
$rs = $conn->Execute("SELECT * FROM Table");

$rs->Close();
$conn->Close();

Using PHP - I open my db - a Access_db.ldb is created and
never closed, preventing me from downloading my db and
making changes.

Any help?
 
Access needs create/amend/delete permissions (or whatever they're called) on
the folder containing the database. This is so it can create, amend &
eventually delete the LDB file (amongst other reasons). This might explain
why your LDB file will not go away. Not sure why that would prevent you
downloading your database, though.

HTH,
TC
 
Back
Top