i have a big..big problem..HOW TO DELETE AN AUTO NUMBER....

this is my coding

sq2= "DELETE * FROM tb_aduan WHERE id_aduan = ' "& aduan & " ' "
set rs =db.execute(sq2)

I assume id_aduan is the autonumber field? If so, you should not be using the quotes around the value. You also don't need the * in the statement. Try this: (assumming you have set aduan equal to a numerical value rather than a string value.)

sq2= "DELETE FROM tb_aduan WHERE id_aduan=" & aduan
set rs =db.execute(sq2)

Tim

You had this issue in one of your prior posts.. you should read the responses that people have posted:

http://www.dbforums.com/t997627.html

Holly book (SQL Server Books Online) will give you a lot of help. The syntax of the deletion of the row you wrote is not correct. The basic syntax is

DELETE [FROM] tableName WHERE ...

ok tq every one...i have settle m problem..i change the id_aduan into number..so my system work smothly...tq