Hi there.
I wish to return the identity of an insert to an access database.

my sql is as below :

nameSQL = "insert into personal (title, first_name, surname, address, post_code, home_phone, mobile, fax, email_address) VALUES ('"&strTitle&"','"&strFirstName&"','"&strSurname&" ','"&strAddress&"','"&strPostcode&"','"&strHomepho ne&"','"&strMobile&"','"&strFax&"','"&streMail&"') ;" &_
"SELECT @@IDENTITY AS NewID;"

However this is as I would use with mySQL. When I use on my access database, I get an internal server error. If I take out the SELECT, the script does work so I know that my problem isn't related to my SQL syntax of the INSERT.

Any input would be appreciated.
Steve

What exactly is the error you're getting?

(Tip: If this is a test server, make sure IIS is configured to send detailed error messages to the client, and make sure 'Enable Friendly HTTP Error messages' is turned off in IE. Then you'll see detailed errors instead of just the usual 'Internal Server Error')