Microsoft KB Archive/101254

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 08:17, 20 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

PRB: OpenTable in VB ODBC App Error: Can't Perform Operation

Article ID: 101254

Article Last Modified on 1/9/2003


  • Microsoft Visual Basic 3.0 Professional Edition

This article was previously published under Q101254


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.


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.


You can use CreateDynaset on any table that uses an ISAM or ODBC (attached tables).


This behavior is by design. It is documented on page 149 of the Visual Basic version 3.0 "Professional Features Book 2" manual.

Additional query words: 3.00

Keywords: kbprb KB101254