Error message when you try to create a new company in Accounting Professional 2008 or in Accounting Express 2008: The following database error occurred: Incorrect syntax near X

Error message when you try to create a new company in Accounting Professional 2008 or in Accounting Express 2008: The following database error occurred: Incorrect syntax near ‘X’

Article ID : 952158
Last Review : May 15, 2008
Revision : 1.1
On This Page

SYMPTOMS

When you try to create a new company in Microsoft Office Accounting Professional 2008 or in Microsoft Office Accounting Express 2008, you may receive an error message that resembles the following:

The following database error occurred: Incorrect syntax near ‘X’. Unclosed quotation mark after the character string ‘EXEC master..XP_FileExist @sql, @res out SELECT CAST(@res AS BIT)’.

Back to the top

CAUSE

This problem occurs if the company name or the user account name contains a special character. For example, this problem occurs if the company name or the user account name contains an acute accent (’), an ampersand (&), or a hyphen (-).

Back to the top

WORKAROUND

To resolve this problem, verify that the company name or the user account name contains a special character. Then, use one of the following methods to delete the special character.

Back to the top

Method 1: Delete the special character from the company name

1. Start Accounting Professional 2008 or Accounting Express 2008.
2. On the Welcome to Quick Start page, click Start a new company.
3. In the Company name field and in the Legal name field, type a company name that does not contain a special character.
4. Enter the relevant data for the company.
5. Follow the steps in the Company Setup wizard, and then click Finish.

Back to the top

Method 2: Delete the special character from the user account name

1. Create a new user account. To do this, follow the steps for the operating system that you use:

• Windows Vista

If the computer is a member of a domain, follow these steps:

a. Open Microsoft Management Console. To do this, click Start, type mmc in the Start Search box, and then press ENTER.

Note If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.

b. In the console tree, click Local Users and Groups.

Note If you cannot see Local Users and Groups, Local Users and Groups is not installed. To install Local Users and Groups, follow these steps:

1. On the File menu, click Add/Remove Snap-in.
2. Click Local Users and Groups, and then click Add.
3. Click Local computer, and then click Finish.
4. Click OK.
c. Click the Users folder.
d. Right-click Action, and then click New User.
e. In the New User dialog box, type the appropriate information, and then click Create.
f. Click Close.

If the computer is a member of a workgroup, follow these steps:

a. Open User Accounts. To do this, click Start, type User Accounts in the Start Search box, and then click User Accounts in the Programs list.
b. Click Manage another account.

Note If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.

c. Click Create a new account.
d. Type the name that you want to use for the new user account, click an account type, and then click Create Account.
• Windows XP

a. Click Start, click Control Panel, and then click User Accounts.
b. In the Pick a task list box, click Create a new account.
c. Type the name that you want to use for the new user account, and then click Next.
d. Click an account type, and then click Create Account.
2. Log on to the computer by using the new user account.
3. Start Accounting Professional 2008 or Accounting Express 2008.
4. Create the company.
5. Log off the computer, and then log on to the computer by using your regular user account.
6. Open the company that you created in step 4.

Back to the top


APPLIES TO
• Microsoft Office Accounting Professional 2008
• Microsoft Office Accounting Express 2008

Back to the top

Keywords: 
kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB952158

Back to the top

 

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
Microsoft Corporation. All rights reserved. Terms of Use | Trademarks


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image