I have a bunch of php scripts that connect to a MS access database. These all worked fine until an update of the windows server 2003 software, now they dont 
The connection script is simple:
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=N:\\Shared\Database\db2_3_be.mdb;user=Matt;pass=password;") or print "cant open connection"
Im suddenly getting cant open connection messages.
User and password are correct.
I can access the database using MS access itself.
I am wondering if it is to do with user permissions. Clicking on the database and going to properties->security has a few users - Administrators, Everyone, SYSTEM and users. I have a vague recollection of there once being something else in there - web users or internet or something. This was set up four years ago though.
Any ideas?
Thanks,
Matt
The connection script is simple:
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=N:\\Shared\Database\db2_3_be.mdb;user=Matt;pass=password;") or print "cant open connection"
Im suddenly getting cant open connection messages.
User and password are correct.
I can access the database using MS access itself.
I am wondering if it is to do with user permissions. Clicking on the database and going to properties->security has a few users - Administrators, Everyone, SYSTEM and users. I have a vague recollection of there once being something else in there - web users or internet or something. This was set up four years ago though.
Any ideas?
Thanks,
Matt