Update Access table from Perl script via ODBC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: messengertj (messengertj_at_discussions.microsoft.com)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 00:17:02 -0800

I'm trying to update an Access table from a Perl script with DBI and
DBD::ODBC. (There is serious number crunching involved that I already have
programmed in Perl, and I haven't used Basic for anything much in 35 years.)
To my surprise I didn't have much trouble connecting. SELECT works fine too,
but UPDATE gives me the "Operation must use an updateable query" message.
Since this is a simple one-table update, it's the permissions problem, not
the cross tabs problem. As a newbie to Access, I'm unfamiliar with setting
permissions in it -- somewhere in the Windows XP, DSN, Access chain I don't
have write permission. Or maybe it's the Internet Guest account. (This same
query works fine on a MySQL database where I understand the permissions
better.) Help! And words of one syllable please. (The Read Only box is NOT
checked in the DSN.)

Relevant Pages

  • Re: Update Access table from Perl script via ODBC
    ... running my Perl script as a CGI script through IIS and that I might have ... set permissions for IUSR_machinename. ... > folder where the MDB file is located. ... > Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • RE: VBScript to audit shares and share permissions
    ... these shares aren't published in AD to my knowledge so I think I'm ... file system level (and maybe some other permissions). ... Free time? ... You can use a Perl script that produces the same output, ...
    (Focus-Microsoft)
  • Re: Update Access table from Perl script via ODBC
    ... Recognize that user ids and permissions are part of the operating system, ... > running my Perl script as a CGI script through IIS and that I might have ... >> Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: problem after upgrade
    ... If I understand your perl script is creating directories and files. ... Check your NTFS permissions. ... you will have to e.g. five IUSR_account permissions to create ... these files and folders (it does depend on how you wrote your script -- but ...
    (microsoft.public.inetserver.iis.security)
  • Solved! Not IIS afterall..
    ... farting around with the permissions for 3 days because ... DB in the same folder and created a new DSN. ... Dead. ...
    (microsoft.public.inetserver.iis.security)