PRB: OpenTable in VB ODBC App Error: Can't Perform Operation (101254)
The information in this article applies to:
- Microsoft Visual Basic Professional Edition for Windows 3.0
This article was previously published under Q101254 SYMPTOMS
The OpenTable method is not supported in Visual Basic version 3.0 for
ODBC data sources. If you attempt to use it in an application that
uses ODBC data sources, you will see this error message:
Can't perform operation; it is illegal.
CAUSE
Visual Basic version 3.0 introduced a new layer of database management,
the Microsoft Access engine, that lies between Visual Basic itself and
the ODBC drivers. This new layer allows version 3.0 to work with Microsoft
Access, FoxPro, Paradox, and dBASE databases. However, the Microsoft Access
engine does not support using OpenTable on ODBC data sources, or any table
that is not part of a Microsoft Access database (.MDB). Therefore, when you
attempt to use OpenTable on tables that are not Microsoft Access tables or
that come from on an ODBC data source, Visual Basic version 3.0 generates
the error.
WORKAROUND
You can use CreateDynaset on any table that uses an ISAM or ODBC (attached
tables).
STATUS
This behavior is by design. It is documented on page 149 of the Visual
Basic version 3.0 "Professional Features Book 2" manual.
| Modification Type: | Minor | Last Reviewed: | 1/9/2003 |
|---|
| Keywords: | kbprb KB101254 |
|---|
|