This tutorial helps you to understand: Connecting ASP Pages to MS Access Databases Persisting Data to MS Access Databases Protecting Data in SQL Statements
To database or not to database? Test of consumed resources (processor, memory) and results with file upload to database or file system. Test of JetOLEB connection to MDB, test of MSSQL 2000 and AppendChunk method and UPDATE text SQL command.
This is an article on executing all or none database queries using ASP-Database transactions. Must read for ASP-Database developers. Sample Database and Code available for download.
This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.
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 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.
If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The advantage of knowing how to do this is that you will be able to manage your SQL Server database via Enterprise Manager over TCP/IP, yourself.