coldfusion flash integration: I get the follow syntax error when trying to run the following SQL:

INSERT INTO USERS (username, fullname, salt, password) VALUES ('stephen7',
'Stephen Barton', 'FFGTHYTHRYH', 'C84B40309079A427A875CAE3F46C7C9B')

I have run the SQL directly in Access and the statement works fine. Is the
problem that I am using Access 97? I am running ColdfusionMX7 and using the
Microsoft Access with Unicode driver.

Thanks,
Stephen

You have not posted the actual error message, just the sql statement, but

password is a reserved word, while it may work directly in access, it will
correctly format the statement while the driver will not

So, enclose in brackets [password]

Note: the same could be said about the table name as well and possibly salt.

As well ensure that the column data types are what's required for the data
being entered.

Ken

Sorry about not posting the SQL error, but it was in Swedish... I thought it
may have been a reserved word issue, so I changed 'password' to 'myPassword'
but the problem persisted.

Then I found this Tech Note:

http://www.adobe.com/go/2d2a7a19

which solved the problem.

Thanks for your time.

Stephen