Microsoft Access is very much useful for Web Application

Access database often outgrows its original purpose. When that happens, you look applying band-aid technology or upgrading to a more powerful database system, such as SQL Server Express or even SQL Server. But before you toss Access out the window and start signing purchase orders for consultants, developers, licensing, and new hardware, consider one more option turning your Microsoft Access development application into a Web-based application.

Best Microsoft MCTS Training, Microsoft MCITP Training at certkingdom.com

* Client versus server: A server-side database, such as My SQL, SQL Server, and Oracle, evaluates requests on the server side and then returns data to the client. Jet, on the other hand, lets the client do all the work. Jet is the database engine behind Access. If the database .mdb is on a network server, the client still does all the work. The server simply responds to client file requests. This arrangement retrieves more then just the data across the network. As a result, indexes and unused data clog the network and slow things down. An alternative is to place the Access database on your Web server's local drive and then build the interface on the Web server. Doing so creates an ad hoc server-side database that handles transactions on the server. Requests from the client are in Hyper Text Transfer Protocol format instead of SQL. To overcome above difficulties put the Microsoft Access Database .mdb file in a folder that isn't shared. That way, users won't have direct access to the database. Their only access will be via the Web server. Your code will serve as the layer that allows users to interact with the actual data.

* User Friendly: Every Windows OS since Windows 98 has had personal Web server capabilities. That means you can develop and test a Web site using a laptop running Windows 98 (or later). Using an Access database as the data source has a few benefits. There's no need to maintain a network connection to a live server. You can copy the live system and its database as just a bunch of files. You don't have to import, export, or attach database

files. Besides above all excellent feature of access database offers the ability for programmers to create Database driven web applications using the programming language like Java and so on.