If you are within the ASP model Win32::ODBC should be all you need. I understand the want to stay with DBI, but the win32 module is fine for this

The DSN can point at access, that shouldn't be a problem, though SQL or mySQL would be better.

    use Win32::ODBC;
    my $DSNName = "PHOTODSN";
    local $db = new Win32::ODBC ("DSN=$DSNName;UID=photouser;PWD=photo
+#user") || die "Error: " . Win32::ODBC::Error();

    my $sqlstrs = "UPDATE......";

    if(!$db->Sql($istr)){
        print "Succeeded \n";
        return 1
    }else{
       print "Failed ". Win32::ODBC::Error();
       return 0;
    }
[download]