ADO: An application programming interface (API) to access relational database management systems.
ADO is provided as a DLL, and usually installed at "c:program filescommon filessystemadomsadox.dll".
ADO can access databases connected through ODBC data source names (DSN).
ADO can also access MS Access database files.
ADO is built on top of OLE DB technology.
ADO API is very similar to DAO.
This chapter shows you how to use ADO to connect ASP pages to MS Access databases. It also shows various interesting issues related to taking user input data to database and retrieving data from database to Web pages.
But why? I read Part I and I was able to implement a simple database program very easily. Why would I need to learn anything more?
You might have implemented some database program.. but I am sure it would be a very simple one. You may even be able to implement a good database program without Joins. But you wouldn't be using the features of SQL that let you do the same work much easily. Without Joins, you may manage SQL.. but with Joins you could do things very easily
This application is for the beginners who wonder how to build their own web database system on their own computers. I will use Microsoft FrontPage98 and Microsoft Access in the demonstration. The reader should be familiar with the RDBMS concept and know how to use Microsoft Access tool to build a local database system. They should also have the Northwind.mdb file, which is included in Microsoft Office 97.
Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.