Either the database is opened allready, and exclusively, or you have to give a username/password with sufficient rights, which you are not doing, with that command.
Luis
Emperor Kang Xi wrote:
Hi all,
I need help to solve my problem, I use ADO to connect MS Access database; the data is store in another server computer; I have try two different way to access the data, and below is the code:
-----------------------------------------
//$dbName = "\\SERVER\mdb\mydata.mdb";
$dbName = "X:/mdb/mydata.mdb";
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=$dbName;Persist Security Info=False");
output:
------------------------------------------
*Warning*: (null)(): Invoke() failed: Exception occurred. *Source*: Microsoft JET Database Engine *Description*: The Microsoft Jet database engine cannot open the file 'X:\mdb\mydata.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Thanks ------------------------------------------------------------------------ åç ------------------------------------------------------------------------ Walla! Mail - get your free 1G mail today <http://www.walla.com>
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
