A few questions about Access databases have come up in regards to ASP. One of the first things you have to do is to make sure your database is in a directory that is writeable by the web server. You can’t typically put your database in your web directory because your web directory is often marked as read only. I will typically make a separate directory outside the web site hierarchy and mark it as writeable for my Access databases. Of course, I personally prefer SQL Server, but your mileage and capabilities may vary.
The other question is in relation to which provider to use for hitting Access databases. If you’ve got Access 97 databases, you can use either the Jet 3.51 or Jet 4.0 providers. However, if you’ve got Access 2000 databases, you have to use the Jet 4.0 provider. If you don’t control your web server (such as in a virtual hosting situation), you’ll need to check with your provider to see which ADO providers are available on the server.