Receive the following error when attempting to delete a user in Helpdesk Internet Edtion.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
/helpdesk/maintenProcesser.ASP, line 63.”
This is usually returned if the users name has an apostrophe in it such as O'Neil. Helpdesk Internet edition does not handle the appostrope correctly and forms an invalid SQL statement which fails, returning the syntax error. A simple workaround is to delete the user within the Helpdesk/SupportCenter thick client rather than Internet edition.
Helpdesk/SupportCenter Internet Edition 6.6