deleting primary key

Fary4u

i'm trying to delete the value from Access DB but the problem is following

Expand|Select|Wrap|Line Numbers

 
Error Type:

Microsoft JET Database Engine (0x80040E07)

Data type mismatch in criteria expression.

the id is primary key & auto number .

Expand|Select|Wrap|Line Numbers

 ors.open "select * from str where id='" & a & "'",ocon,adOpenDynamic,adLockOptimistic
 

any body know where the problem gonna be ?

GazMathias

Hi there,

Without knowing your DB I would hazard a guess at this:

Expand|Select|Wrap|Line Numbers

where id='" & a & "'"

Is your id field textual in nature?

If not:

Expand|Select|Wrap|Line Numbers

where id=" & a

Gaz

jhardman

Gaz is right, let me clarify just in case it wasn't obvious. If you are sending text to access you need to enclose it in single quotes (Select * from BytesUsers where username = 'jhardman') but if you are sending a number you cannot use quotes (select * from BytesUsers where ID = 4321)

Jared

deleting primary key

re: deleting primary key

re: deleting primary key

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about