Front-end and Back-endįirst of all, let’s clarify how the client’s Access database would be opened. These are essential for the use of Access from PHP. One other item that’s standard with a Windows installation is the availability of ODBC drivers. In this article I’ll focus on the essential elements of PHP you’ll need to use an existing Access database online. In effect, what you’ll be doing is replacing the forms listed under the Forms tab in Access. Building an interface may sound daunting, but it needn’t be. (Linux hosting is possible too, but that’s slightly more complicated.) The hosting is not enough in itself, though, because you also need to build an interface allowing them to read and write to the database. To make the transition to online databases easier, the existing Access database can be kept unchanged and simply uploaded to a suitable Windows host. And all as a result of moving an existing Access database file from an offline to an online location.
That is: storing the database on a server means that any authorized person be able to use the company’s product database using nothing more than a browser. There’s another advantage to having an online database, but which is a significant – multi-user access. In addition, having their product database online opens the door to using it as the basis of a website for their business. Wouldn’t it have been better for them to able to maintain their database where ever they were? Of course, but how? Simple – put it online. There had been too many instances when they needed to use the database but weren’t near the computer where they kept their database. But increasingly this working arrangement had proven to be limited. A previous client of mine had an Access database of products they sell, which they had been using offline.
0 kommentar(er)
