When you created the DSN, did you specify a system database? This is the radio button option at the bottom of the ODBC Setup window. Selecting this option allows you to specify an .mdw file. It is the mdw file that contains the security information for Access databases.
