I can't get ODBC to work The examples in the documentation that are very useful. Make sure you have created a ODBC System DSN to the database. IIS pools ODBC connections which means that opening an ODBC connection per page is not an expensive operation. This will fail because the SQL string will contain an odd number of single quotes. Should I use Access or SQL That Depends.
Access is cheap.
It is easy to create tables and modify them as needed. It is hard to make a backup of an Access database without taking it offline. Using SQL Server constraints and transactions makes it easier to protect the database from logical coruption. Personally I only use SQL Server for both development and production. You can only access a text field in the record set once, then it is gone.