MS Access and PHP
Ok, I have a feeling my problem isn't with my PHP code, but I'm hoping someone may have come across a similar problem that can help me.
Basically, I have a php site writing to an Access database. I believe the server is running IIS 5.0. Everything has been working fine...all the data is writing to the correct tables, no errors or database connectivity problems.
Here's the issue, I just updated the database with several new tables for a new section of the site. Now when I try to navigate the site, anywhere that the database is accessed, whether it's from the existing pages that previously worked or the new section, a connection can't be made to the database.
Does anyone know why this is occurring? I'm thinking it may be a permissions thing or configuration problem on the server, but all I did was replace the existing database file with a new one. Wouldn't permissions and such stay intact?
Or could it be that someone has the database open, which I've noticed causes the same error when I'm using my local server. If this is the problem, is there a way to avoid errors when someone has the actual database file open? A way to lock the database so it can be opened and accessed (via a web page) at the same time?
I'm hoping someone has come across this problem while using PHP and may be able to shed some light on the problem.
Any help would be appreciated.
Thanks,
Tjay
|