WIN32::ODBC - Unable to make Database connection

[Guest wmitty]

Not sure this is right forum, but here goes:

 

Runnins IIS (personal web server) and trying to update Access 2003 database

via perl script using the following:

 

$DSN = "Test";

use Win32::ODBC;

$db = new win32::ODBC($DSN);

$db->sql("select * from SiteVisits where script_name = "counter" ");

 

Error: [-1032] [] "[Microsoft][ODBC Microsoft Access Driver] The Microsoft

Jet database engine cannot open the file '(unknown)'. It is already opened

exclusively by another user, or you need permission to view its data."

 

As best I can determine tll files/databases have "full" permissions.

 

Help!!!

 

If this is not the correct forum please direct me to the correct one. Thanks.

This attempt nets the following error: