Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it‘s hard to separate the database stuff from the rest of the code so I made this example. I even removed the includes and everything.

This is an introductory tutorial on ASP data access. It covers Connection Object, Command Object, and Recordset Object.

Complete tutorial on editing and updating records in the database. Each and every step explained in detail for ASP beginners. Both Connection and Recordset Objects discussed.

This is a complete tutorial on adding records to the database via ASP for beginners. Both Connection and Recordset Objects discussed. Also get an insight on 'insert' SQL statement.

Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures.

This tutorial shows you step-by-step how to incorporate MS Access databases into your web site using ASP.

In order to connect to an Acees database with ASP through ODBC using a DSN file, you'll need to have full access to the server to create the DSN file, something that can be difficult if your site is hosted somewhere. This lesson will teach you an alternative connecton method, a DSN-less connection. As tests has shown, an DSN-less connection to Access gives you better performance. You can have up to 20-30 simultaneous users on the db without problems.

This is a nice simple tutorial on how to manipluate a MS Access database using ASP. It will teach you how to add, remove and modify data from an Access database as well as connecting and disconnecting to the database in ASP.

This is a tutrial about connecting an Access database with ASP pages. It focuses on connecting Access with PWS 4.0 on a Win95 machine. You can use the same procedure on Win98. It also shows you how to create a database table in Access and how to retrieve it's content and display it through ASP.

SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn't tell you where the error is. This tutorial provides a nice summary of SQL statements.