Very Computer

I am trying to insert a populated record into a table and getting an error:
Syntax Error in INSERT INTO statement
my code is recordset1.open "insert into table (field1,field2,count)
values(string,string,autonumber)",connection1,adopenstatic,adlockoptimistic

I have tried deleting the last column "count" but gives me a missing
parameter error
I suck at ms access. can anyone recommend a good access book since it has a
few peculiarities from normal ansi sql?
Thanks in advance...

Quote:> I am trying to insert a populated record into a table and getting an
error:
> Syntax Error in INSERT INTO statement
> my code is recordset1.open "insert into table (field1,field2,count)

values(string,string,autonumber)",connection1,adopenstatic,adlockoptimistic

why try and insert a value into your autonumber column ?  If that's the
indexed primary key of the table you are inserting into there should be no
need to try and insert into that col...

Or have I got the wrong end of the stick with your SQL ?
S
___________________________________________
http://www.blackdogwebdesign.co.uk/irc
real-time chat over http with no applets...;0)>
http://www.boardmad.com

I wouldn't think you would need to insert into the count column, but when I
leave it off, I get the error message "no value given for one or more
required parameters.". It's very troubling

:


: > I am trying to insert a populated record into a table and getting an
: error:
: > Syntax Error in INSERT INTO statement
: > my code is recordset1.open "insert into table (field1,field2,count)
: >
:
values(string,string,autonumber)",connection1,adopenstatic,adlockoptimistic
:
: why try and insert a value into your autonumber column ?  If that's the
: indexed primary key of the table you are inserting into there should be no
: need to try and insert into that col...
:
: Or have I got the wrong end of the stick with your SQL ?
: S
: ___________________________________________
: http://www.blackdogwebdesign.co.uk/irc
: real-time chat over http with no applets...;0)>
: http://www.boardmad.com
:
:
:
:

Quote:> my code is recordset1.open "insert into table (field1,field2,count)

values(string,string,autonumber)",connection1,adopenstatic,adlockoptimistic

First, Access will not let you write to an autonumber for any reason except
to delete the record.  Second, switch to SQL view.  Access declares
parameters in a funky way.  If your statement works like the one below, then
lose the parameter that's still declared for the autonumber once you remove
the autonumber thing from the insert and value clauses.

INSERT INTO ThisTable
    (Field1, Field2)
VALUES
    (ThisString, ThatString)

Another thing that you should do is sort of a matter of form, since it
doesn't seem to be related to what your asking:

oRS.Open(...) is for SELECT statements that return rows.

For INSERT, UPDATE and DELETE, you should use the Execute method of the
Connection object.
--
Peace & happy computing,

Mike Labosh, MCSD MCT
"Escriba coda ergo sum." -- vbSensei

Quote:> I am trying to insert a populated record into a table and getting an
error:
> Syntax Error in INSERT INTO statement
> my code is recordset1.open "insert into table (field1,field2,count)

values(string,string,autonumber)",connection1,adopenstatic,adlockoptimistic

Quote:

> I have tried deleting the last column "count" but gives me a missing
> parameter error
> I suck at ms access. can anyone recommend a good access book since it has
a
> few peculiarities from normal ansi sql?
> Thanks in advance...

Is it possible to use the following syntax, or is this DAO specific?

With rs
    .addnew
    .field("Column1") = Value1
    .field("Column2") = Value 2

    ... etc.

    .update
End With