PHP & Microsoft Access

[stezz]

Hi!

I am working on a computer database project at school using Microsoft access. I am making a database system for a local driving school. Part of my project will be to create a website where each learner driver with this school can login and make lesson bookings, cancel booking etc etc.

I have a login that I coded using Visual Basic that queries a table for the username and password. This all works fine.

My question to you is would it be possible to have PHP connect to an MDB file so bookings can be made, canceled etc online? I saw an artice on this site about connecting to an MS SQL server. But, what I need to do isn't the same thing.

I plan to run this website on a windows box running apache and (obviously) PHP. If this is not possible, would it be possible is there any way that I can "make" it possible?

I will be truly greatful for any help with this matter.

Regards, Stezz.

[harlowhair]

Firstly, as you've probably already guessed, I'm going to ask why you are using MS Access. Its rubbish. If you can use MySQL, I would suggest it - its even free! An analogy between the two would be like someone offering you a brand new, fully furnished house for absolutely nothing, and then turning them down in favour of buying a 6 foot square shed from argos. I don't have anything against Microsoft at all, its just that access is rubbish.

Anyway, enough of the rant, if you do have to use it, then you can access it via ODBC or using COM objects. I know that there are several good articles on this site about COM but you may want to check this link out

http://www.phpbuilder.com/columns/siddarth20000228.php3

It talks you through using ms access and PHP on an apache server running on Windows. Hopefully theres some helpful sstuff amidst my ravings