Re: Permission deny on connecting MS Access database

This is not a PHP error, it's a DB error, and the message is very clear. 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>