Why is this a syntax error?

[MikeMarq]

When I run this code I get this error message "Syntax error in INSERT INTO statement". Can anyone explain why my command is a syntax error? Thanks. rsGuest.Open("Guest", ADOConnection, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic) Dim command As String command = "INSERT INTO Guest(Guest ID) VALUES('1111')" ADOConnection.Execute(command, rsGuest)

[Ashfield]

There are two possible reasons I can see. Firstly, your syntax is wrong: command = "INSERT INTO Guest(Guest ID) VALUES('1111')" Should be command = "INSERT INTO Guest**[**Guest ID**]** VALUES('1111')" Also, is [Guest ID] an identity (autonumber) column?

Bob Ashfield Consultants Ltd

[Krish KP]

column name Guest ID is having space so it cannot be used directly use it like this command = "INSERT INTO Guest([Guest ID]) VALUES('1111')"

Regards KP

[Ashfield]

Sorry, thats what I meant - you need to put Guest ID in square brackets, I didn't mean to lose the () round it. Old age and failing eyesight to blame ;)

Bob Ashfield Consultants Ltd