03-02-2008 06:12 PM
06-19-2008 12:33 PM
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 18.104.22.168, 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????
06-28-2008 08:43 AM
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.
06-28-2008 08:48 AM
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.
06-28-2008 09:08 AM
10-02-2008 03:27 PM
Solution found as referenced in a previous post by Michael Lazarus
Under Tools, Database Maintenance, Check & Repair
ACT! Consultant - Sydney Australia