Database may be open by MS Access application.
I don'n know how to work around, but i was happen when I worked with ASP
on IIS 4.0 and MS Access 8.0
Andris
> I've just tried creating an entirely new database and receive the same error
> as well as reparing the old database. I've restarted the web server, still
> the same problem.
>
> The access 2000 db is on an iis 4.0 server which worked fine previously.
>
> Thanks,
> Aaron
>
> "Gonzalo Vera" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> This usually happens when another user opens a table for modification
> (table definition): the table gets locked to all access. If you're
> only running localhost try "repairing" your database: maybe you got a
> corrupted table or db. Also if you're only on localhost, restart your
> computer to make sure all files get closed. If you're not only running
> localhost, and the database is on a remote server, you might have some
> more trouble, but still would need to do some/all of these actions.
>
> That was like a gunshot, but it has worked for me in the past... ;)
>
> Gonzalo.
>
> > Up till late yesterday I was able to query my database but now I receive
> > this error.
>
> > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The
> Microsoft
> > Jet database engine cannot open the file '(unknown)'. It is already opened
> > exclusively by another user, or you need permission to view its data., SQL
> > state S1000 in SQLConnect in wwwroot\test.php on line 2
>
> > My script is only trying to make a connection at this time and it does not
> > work
>
> > <?php
> > $cnx = odbc_connect (equipment2,'','');
> ?>>
>
> > What went wrong? Thanks,
> > Aaron
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
