M
messengertj
I'm trying to use a Perl script to update records in an Access database.
(There is some fairly serious number crunching involved in calculating the
field values and I'm more comfortable in Perl than I am in VB.) I'm using
the ODBC DBD for Perl. I have no trouble connecting (I was surprised), and
running SELECT queries, but I'm having trouble running UPDATE. I get the
"Operation must use an updateable query." error on every operation. This is
a single table query, so it's not the cross table problem, it's the
permissions problem. Somewhere in the Windows XP permissions, the DSN, the
Access permissions, I'm missing something. I'm a newbie with Access and I
need words-of-one-syllable help. The same query successfully updates a MySQL
database. A page at MS suggested that I need to give the Internet Guest
account write permission on the .mdb, but didn't really explain how to do
that. (And "Read Only" is NOT checked in the DSN.)
(There is some fairly serious number crunching involved in calculating the
field values and I'm more comfortable in Perl than I am in VB.) I'm using
the ODBC DBD for Perl. I have no trouble connecting (I was surprised), and
running SELECT queries, but I'm having trouble running UPDATE. I get the
"Operation must use an updateable query." error on every operation. This is
a single table query, so it's not the cross table problem, it's the
permissions problem. Somewhere in the Windows XP permissions, the DSN, the
Access permissions, I'm missing something. I'm a newbie with Access and I
need words-of-one-syllable help. The same query successfully updates a MySQL
database. A page at MS suggested that I need to give the Internet Guest
account write permission on the .mdb, but didn't really explain how to do
that. (And "Read Only" is NOT checked in the DSN.)