What special characters cannot be used in the access database?

Although Microsoft Access database does not restrict the use of special characters in object names or field names, such as number marks (#), periods (,) or double quotes ("") marks, but if We have used special characters and may encounter unexpected errors.

Therefore, Microsoft recommends that you do not use special characters in database object names in Access databases or database projects. This article will discuss some special characters that you must avoid using. We already know that certain problems occur with these special characters.

When you use Access or use other applications such as Microsoft Visual Basic applications or Active Server Pages (ASP) applications, you must avoid using the following special characters:

Spaces

Double quotation mark "

Apostrophe '

grave note `

Number mark

#Percent sign %

Greater than sign >

Less than sign

Exclamation mark !

Period .

Brackets [or ]

Star *

Dollar sign $

Semicolon;

Colon:

Question mark ?

Caret ^

Parentheses (or )

Plus sign

Backslash \

Access Naming Convention Microsoft recommends that you do not use function names, variable names, field names, or database objects ( For example, use a period (.), exclamation point (!), accent mark (`), square brackets ([ ]), space ( ), or double quotation mark (") in the name.

For more information about naming conventions in Access, click Microsoft Access Help on the Help menu, type names for fields, controls, and objects in the Office Assistant or the Answer Wizard Name the rule and click Search to view the topic.

Some known issues may occur if you use the following special characters in Access. The following situations describe when you must avoid using these special characters:

When you export database objects to other file formats (such as the Microsoft Excel file format, HTML file format, or some text file format) , do not use number signs (#) or periods (.) in database object names or field names.

When you use hyperlinks in Access, they are stored as modified "Notes" fields, separated by number signs (#). Therefore, numeric tokens are considered reserved words in Access. Do not use number tags when creating hyperlinks.

If you import a text file into Access and the text file contains tabs or other special characters, the special characters are converted and then the special characters appear as boxes. Therefore, you encounter unexpected errors when you try to use the imported table. When you import a table into Access, be sure not to use special characters in the source table.

When you use ASP forms to add or modify data in an Access database, you must not use the percent sign (%), plus sign (), or caret (^) in the form. These special characters are not converted correctly in Access databases.

When using a full-width character language, do not use full-width characters in the names of database objects or controls. For example, when using a double-width character language, you must not use full-width parentheses. Using full-width parentheses can cause a compilation error if there is code within an object or control's event procedure.

Related recommendations: access database tutorial

The above is the detailed content of What special characters cannot be used in the access database?. For more information, please follow other related articles on the PHP Chinese website!