Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act 2007 database error message

New Member
Posts: 1
Country: United States

Act 2007 database error message

[ Edited ]

We have just upgraded our act software from 3.0 to Act 9, 2007. Windows Vista PC

 

We get an error when we attempt to backup the database or do an export. This never happened before with the original version.

 

Incorrect Syntax near "HVAC"

unclosed quotation mark after the Char string ; NOSKIP,

Stats=10, NoFormat;

PRC_Maint_BackupDB:Error Executing

Datadase back-up Statement

 

Can someone please tell me what I need to do to fix this problem?

 

Thank you

 

Message Edited by myke on 12-12-2008 03:58 PM
Message Edited by myke on 12-12-2008 03:59 PM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Act 2007 database error message

Please see the following Knowledgebase article for a possible resolution to the issue:

 

Error: "Line 1: Incorrect syntax near 's'. Unclosed quotation mark before the character string', NOS...

 

 

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.