Almost always this is a permissions problem, although unspecified error from the database can be almost any Jet generated error that isn't trapped by ASP.
Make sure the IUSR_xxx web account user (if NT or W2K) has rw permissions to the database, the db folder, and to the temp folder specified in your environment variables TEMP and TMP.