Wrox Programmer Forums
|
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 25th, 2004, 12:30 PM
Registered User
 
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
 
Old October 25th, 2004, 04:33 PM
Registered User
 
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Nevermind my question...I found out what the problem was. The database file didn't completely upload to the server. (argh!!)

Thanks,
Tjay





Similar Threads
Thread Thread Starter Forum Replies Last Post
php and ms access. help? master_paolo PHP Databases 3 March 14th, 2006 01:22 AM
PHP and MS Access darkhalf PHP Databases 2 October 23rd, 2004 04:10 PM
connecting PHP to MS Access pb7 Beginning PHP 5 September 24th, 2004 05:04 PM
MS ACCESS with PHP Ashleek007 PHP Databases 1 March 17th, 2004 02:35 AM
connecting PHP to an MS Access database pb7 PHP Databases 1 September 18th, 2003 04:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.