Skip to main content
Participating Frequently
November 11, 2007
Question

Adding Values from webform to database

  • November 11, 2007
  • 1 reply
  • 215 views
INSERT INTO [form] (COUNTRY, [STATE/PROVINCE], CITY, [DATE], [TIME], EMAIL) VALUES (?, ?, ?, ?, ?, ?)

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/dropinfitness/addclass.asp, line 41

i think the problem is with the " ? "
This topic has been closed for replies.

1 reply

Inspiring
November 12, 2007
"cjamesc" <webforumsuser@macromedia.com> wrote in message
news:fh7q8h$j9a$1@forums.macromedia.com...
> INSERT INTO [form] (COUNTRY, [STATE/PROVINCE], CITY, [DATE], [TIME],
> EMAIL)
> VALUES (?, ?, ?, ?, ?, ?)
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> query.
>
> /dropinfitness/addclass.asp, line 41
>
> i think the problem is with the " ? "

The problem is with permissions on the folder containing the database,
access creates a lockfile in the same folder as the mdb if the user
executing the script doesn't have persmission to access, create or modify
files in that folder the database can't be updated.