Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Adding Values from webform to database

New Here ,
Nov 11, 2007 Nov 11, 2007
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 " ? "
TOPICS
Server side applications
215
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 12, 2007 Nov 12, 2007
LATEST
"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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines