var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: INSERT INTO w/ Autonumber field
Im going crazy here and I hate access with a passion, but I do have a problem so here it is.
I have an access DB called "Entrys" with 6 fields:
First (rest are text)
The autonumber field is screwing me up somehow, here are the queries Ive tried:
INSERT INTO Entrys VALUES ('First', 'Last', 'Company', '123', '555-555-5555', 'firstname.lastname@example.org')
"Number of query values and destination fields are not the same"
INSERT INTO Entrys (first, last, company, code, phone, email) VALUES ('First', 'Last', 'Company', '123', '555-555-5555', 'email@example.com')
"Syntax error in INSERT INTO statement"
INSERT INTO Entrys (ID, first, last, company, code, phone, email) VALUES ('123', 'First', 'Last', 'Company', '123', '555-555-5555', 'firstname.lastname@example.org')
This one actually works, I can assign the autonumber field a value, but thats not what I want. Why wont Access accept the second SQL query?
i just tested both your queries 2 and 3 in access 97 and they work fine
Exactly! You would think Query 2 would work fine by leaving out the auotnumber field from the insert but I get an error everytime. Something is funky
well, when i tested it, i used text for all the columns except ID
perhaps you could double-check your column definitions
or maybe drop and recreate the table
They are all text except for ID
maybe drop and recreate the table
It works for me as well. Just specify all of the columns except for the autonum PK field, and it will work for sure.