This article discusses the special characters that you must avoid because of known issues with these special characters. Therefore, Microsoft recommends that you do not use the special characters in the database object names in the Access database or in the database project. However, if you do use the special characters, you may experience unexpected errors. Microsoft Access does not restrict the use of special characters such as a number sign (#), a period (.), or a quotation mark (") in the database object names or in the database field names. Typically, this problem occurs when you use the following special characters: When you run the query, you are promoted to enter a parameter value. The query expressions include fields that contain special characters. You have a query that contains query expressions. The expression you entered is missing a closing parenthesis, bracket (]), or vertical bar(|). If the field name contains a bracket () or parenthesis (()), you receive the following error message: Malformed GUID in query expression ' ObjectName' If the field name contains a brace (), you receive the following error message: You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks. If the field name contains a percent sign (%), a tilde (~), a semicolon ( ), or a bracket (), you receive the following error message: The expression you entered has an invalid date value. If the field name contains a number sign (#), you receive the following error message: The Expression you entered has an invalid string.Ī string can be up to 2048 characters long, including opening and closing quotation marks. If the field name contains a quotation mark(") or an apostrophe('), you receive the following error message: You may have entered an operand without an operator The Expression you entered contains invalid syntax. If the field name contains a space character, a question mark (?), or an at sign you receive the following error message: Depending on the specific special characters, you receive one of the following error messages:
The query expression includes fields that contains special characters. The object name ' TableName' you entered doesn't follow Microsoft Office Access object-naming rules. If you use these special characters in a table name, you receive the following error message: If you have pasted the name from another application, try pressing ESC and typing the name again. Make sure that the name doesn't contain a period(.), exclamation point(!), bracket(), leading space, or non-printable character such as a carriage return. In this case, you receive the following error message: You use one of the following special characters in the name of a table field: When you use special characters in Access, you experience one of the following problems. This article applies to either a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file, and to a Microsoft Access project (.adp) file.
0 kommentar(er)
