BUG: Data Form Wizard Mishandles '-' in Table or Field Names (193514)
The information in this article applies to:
- Microsoft Visual Basic Learning Edition for Windows 6.0
- Microsoft Visual Basic Professional Edition for Windows 6.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
This article was previously published under Q193514 SYMPTOMS
When loading a form created by the Data Form Wizard, you may receive one of
the following error messages:
Run-time error '-214217900 (80040e14)', "Syntax error in FROM clause"
Run-time error '-214217904 (80040e10)', "No value given for one or more
required parameters"
CAUSE
If the data source for a form created by the Data Form Wizard contains
a dash '-' in its name or in the name of a field, it is required that the
data source name or field name be delimited by brackets in a SQL statement.
The Data Form Wizard does not include brackets around these names.
RESOLUTION
To work around this problem, modify the code created by the Data Form
Wizard by placing brackets around references to any data sources or field
names that contain the '-' character.
Alternatively, data sources and their fields could be renamed to eliminate
'-' characters. This solution could involve more work in general, but may
be acceptable at the beginning stages of application development. NOTE: You should follow standard Windows naming conventions and not include the following characters in your database names:
Although some databases such as Access allow forward slashes ("\"), you receive the above-mentioned error when you use this database through Visual Basic.
STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed
at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 5/12/2003 |
---|
Keywords: | kbBug kbpending kbwizard KB193514 |
---|
|