INSERT INTO with autonumber PK

[Fredde]

I have a problem with an INSERT INTO using ASP connected to Access.The problem is that I get promted
"Index or primary key cannot contain a Null value." when I do the following insert:

INSERT INTO tblHardware(Devicetype) VALUES('something')

Devicetype is not the primary key.

Since I want the primary key to be an autonumber I don't want to insert that number, please help me.

/Fredrik

 

[KenReay]

Hi

I know this is asking the obvious but..

I assume you do have the PK column defined in the table, and it is type autonumber ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[SQLBI]

Fredrik,

I can't comment on ASP as i've never used it, but normally when i run an INSERT statement via ADO to a Autonumber PK, Access inserts the record and adds the PK itself.

Do you have any other fields in this table, especially "required" fields?

Not very helpful, but it may get you thinking.

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[Fredde]

KenReay: Yes.

leighmoore: Yes. The PK adds automatically in ACCESS. There are reqired fields but since I got the message:
"Index or primary key cannot contain a Null value." I assume that it is that filed that is the problem.

/fredrik