Showing results for 
Search instead for 
Do you mean 

Incorrect syntax near 'B'

New Member
Posts: 3
Country: Australia

Incorrect syntax near 'B'

ACT 9 Premium


When creating Subgroups the dialog box appears with this error Incorrect syntax near 'B'


I have seen some earlier posts re this error and Database Repair was suggested but not indication of this fixing was mentioned


If anyone has had this experience or has a confirmed solution would greatly appreciate any ideas - unable to locate any other solutions to date in KB


Kind Regards


Bronwyn Clarke

ACT! Consultant - Sydney Australia

Copper Elite Contributor
Posts: 108
Country: United States

Re: Incorrect syntax near 'B'



After searching, I was unable to locate an exact answer, but I was able to discern that it has everything to do with your database and SQL.  I recommend the database repair.  If this does not correct the problem, then I would trying working the the ACT11Demo database to see if the problem manifests.  If it does, then I would suggest removing and reinstalling Act! using the Actunisntaller.  If it doesn't, then it is a database repair issue.


Hope this helps.



Platinum Elite Contributor
Posts: 14,418
Country: Australia

Re: Incorrect syntax near 'B'