Community
Showing results for 
Search instead for 
Do you mean 
Reply

Bakcup Error - Line 1: incorrect syntax near 's"

New Member
Posts: 1
Country: Canada

Bakcup Error - Line 1: incorrect syntax near 's"

I am trying to create a backup file to migrate data to a new ACT! installation on a Vista computer and receive the following error when I click File|Backup:

 

Line 1: Incorect syntax near 's'

The floating point value '099E456' is out of range of computer representation (8 bytes). Unclosed quotation mark before the character string ',NOSKIP, STATS=10, NOFORMAT'. PRC_MAINT_BACKUPDB: ERROR EXECUTING DATABASE BACKUP STATEMENT

 

How can I resolve this, or migrate the database to the new installation of ACT!.

 

Thanks!

New Member
Posts: 3
Country: United States

Re: Bakcup Error - Line 1: incorrect syntax near 's"

I am getting the same error today.  Trying to back up a database to a flash drive and get the following error message

 

Incorrect syntax near 'Clients'.

unclosed quotation mark after the character string', NOSKIP,

STATS=10, NOFORMAT',

PRC_MAINT_BACKUDB: ERROR EXECUTING DATABASE BACKUP

STATEMENT

 

I have tried to do the database repair and it did not solve the problem.

 

Thank you