Community
Showing results for 
Search instead for 
Do you mean 
Reply

HELP!!!! Incorrect Syntax Near "B"

New Member
Posts: 4
Country: USA

HELP!!!! Incorrect Syntax Near "B"

I am getthing an error message Incorrect Syntax Near "B" when I am trying to enter a new Division.  Help!!!
Nickel Contributor m4y
Nickel Contributor
Posts: 512
Country: Belgium

Re: HELP!!!! Incorrect Syntax Near "B"

Which version exactly?

Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
New Member
Posts: 4
Country: USA

Re: HELP!!!! Incorrect Syntax Near "B"

It is ACT! 9.x/2007 Workgroup
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: HELP!!!! Incorrect Syntax Near "B"

Have you also tried to a database repair as per - http://tinyurl.com/yu8ggx
Always backup the database first :-)
 
If that doesn't help - What's the exact path of the database?
Are you doing this on the server of frmo a workstation?
What exact build of ACT! from Help | About?
New Member
Posts: 13
Country: USA

Re: HELP!!!! Incorrect Syntax Near "B"

Mike,

 

I know the last person wrote several months ago, but I'm just running into this error now, I am using the following:

 

ACT! by Sage Premium for Workgroups 2007 (9.0) (EX Edition) Version 9.0.1.162, Hotfix 1, English (United States)Sage Software SB, Inc.

 

In my situation, we have a server in the office, who the owner is the administrator on.  I am in my office (duh).  We've used the software for a long time now with no issues, but for some reason today I ran into this.  It is happening when....

 

I, for the first time, have added Groups.  I started with Group 'A', then added all its subgroups.  Then, I started w/ Group 'B' and added all its subgroups.  At that point, I realized that all of Group 'B' and its subgroups had a lock next to them.  I didn't intentionally make them private, so I went to Group 'B', changed the Group Info page to say "Public."  All was well.  Next I went to the first subgroup under Group 'B' and went to its Group Info page and changed it to "Public."  It is at that point that if I try to click out of that subgroup it gives the following error message:

 

Incorrect syntax near 'B'.

 

My only way around it is by changing the Group Info page back to "Private" and then moving off like normal.

 

I saw that you mentioned doing a database repair, which I would imagine requires an administrator.  Do you have any other suggestions????

 

Thanks,

Keith Roberts

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: HELP!!!! Incorrect Syntax Near "B"

Is the 'B' in the error message the name of the Group?

 

Are you syncing to the Owner or on a LAN?

 

Yes, I think a database repair is needed.

New Member
Posts: 13
Country: USA

Re: HELP!!!! Incorrect Syntax Near "B"

The 'B' is no where in the Group name at all.

 

And I do apologize, I am pretty well versed with ACT!, but I do have a lot of room for learning!  The 'syncing' is what I'm not sure about.  This office runs all internal, no one remotes in or anything (if that information is needed to you).  ACT! is on the server, and we all get to the centralized database through that server.  Not sure if that answers your Owner/LAN question or not.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: HELP!!!! Incorrect Syntax Near "B"

Yes, it sounds like you're on a LAN... and yes, the ACT! database administrator should do the data repair
New Member
Posts: 3
Country: Australia

Re: HELP!!!! Incorrect Syntax Near "B"

Did you find a solution to this issue Incorrect syntax near 'B'
New Member
Posts: 3
Country: Australia

Re: HELP!!!! Incorrect Syntax Near "B"

Solution found as referenced in a previous post by Michael Lazarus 

 

Under Tools, Database Maintenance, Check & Repair

 

Kind Regards

 

Bronwyn Clarke

ACT! Consultant - Sydney Australia

bronwyn@eyecatchers.net.au