How can I connect an Access 2003 database with php?

Posted on 2010-09-17
Medium Priority
Last Modified: 2013-12-13

I want to get data from the database and edit it by using a web page.

A supervisor will login to the web page and he will be able to see only his spervisees. Then, he will edit some fields.

Second question will be, where do I need to have the database?

Thank you.  
Question by:iscivanomar

Accepted Solution

jkurzner earned 1000 total points
ID: 33705238
It depends on how you want to connect to it.  YOu can use a DSN connection or a direct connection and the web page would code it slightly differently.  to properly answer the question you would need to post your database and more details about what you want to do
LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 1000 total points
ID: 33705347
On commercial hosting (IIS), the MDB will be placed in a directory that is not web accessible.  This is to prevent people from downloading the database.  Then a DSN will be provided that will create access from the page to the database.

Author Closing Comment

ID: 33825810
Thank you for you answer, I read about it and I found what I need.

For now, we are not going to use this solution. We have other application that other sites use that could work for this purpose.

Thank you and have a good day.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question