Re: SQL Error

The error is caused by your other program - at the point where it opens the database exclusively, nothing will be allowed to open it no matter what. So what you have to do is to change the settings in your other program and make it open the database non-exclusively. No way around it. Now, if your database is a "read-only" database, you could make 2 copies of it, and when you update one, replicate it to the other... But if it's a live database with changes happening, that method won't work... Pascal Jolin ----- Original Message ----- From: "Gary" <kcooke@mediaone.net> To: <php-db@lists.php.net> Sent: Sunday, December 03, 2000 10:01 PM Subject: [PHP-DB] SQL Error > Hi everyone, > I'm brand new to PHP Just today! I love it so far! I am though having > trouble with a SQL error. Here it is: > > Warning: SQL error: [Microsoft][ODBC Paradox Driver] The table 'Fixtures#DB' > is already opened exclusively by another user, or it is already open through > the user interface and cannot be manipulated programmatically., SQL state > S1000 in SQLExecDirect in D:\Apache\htdocs/fixtures.php on line 13 > > Is there anyway to avoid this? It is because the Fixtures.db table is > opened by another program. Of which can not be avoided. > > Thanks, Gary > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >