database query

nilesh
07-07-2002, 02:25 AM
I have created table in db. i'm trying to insert data in to db through ASP code
using "insert into" statement:
conn.execute("insert into tblname values ('" &fname &"','" &lastname &"')

this statment gives err:
"operation must be an updatable query."

so, what will be the problem?
please quide me.

Rezner
07-07-2002, 08:17 AM
If you are on a network, make sure that you have write permission into the directory the db is located in.

Also, make sure you are runnin Jet 4.0 and not Jet 3.51. Just to be on the safe side, I'd go to the microsoft site and get the MDAC 2.7 refresh.

Thinker
07-07-2002, 11:00 AM
You also need the table set up correctly so that the first and last
name fields together make up a primary key, or you need to set
an autonumber primary key field, or you need to include the value
for the primary key field in your insert.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum