I am a rather happy man. I have just learnt from the w3schools site and a little tweaking that I can very easily connect PHP to a Microsoft Access(R) database. Yes, I knew it was possible but I expected a number of errors.
I very easily connected to my secured database (it uses Microsoft Access's user-level security). I can also read data from queries that I have created in Access. What's more, we use some software to hide the database files and the security file. The connection still worked even with hidden files! Excellent! Simply excellent!
One of the reasons for my exuberance is a particular task I have pending, of creating a huge document that contains data from an Access database. The document is currently created partly in Word and partly using Access reports. Access forms and reports were a little cumbersome for this task. Now I have the chance to use PHP's scripting while the users fill in the data as before in Access. Now i need to learn how to generate PDF's using PHP. I already have some links on that.
No comments:
Post a Comment