Use Access 2000 as your ADO Provider in ASP

Databases provide the key between boring, static pages and exciting, dynamic ones. When you move an ASP to the production server, you'll no doubt want to use a robust database like SQLServer to handle the large amount of data your Web sites will require.

However, for development, you may not always need such a heavy-duty program. Enter Microsoft Access. This tiny whiz of a database provides a great way to test your data-driven pages during development. If you've just begun to use Access 2000, though, you may have wondered how to make it your ASP ADO Provider. Fortunately, it's as easy as changing a few digits. Previously, with Access 97, the Provider string looked as follows:

strConnection = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & Server.MapPath("myDB.mdb")

To utilize Access 2000, simply change this string to

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("myDB.mdb")

Source: Mike D. Jones
Viewed 14199 times