Lists the available tables in a connected data source.

Defined in

ODBCConnection

Syntax

tableArray = odbcConnection. ListTables( [ dataSourceName$ [ , userID$ [ , password$ ] ] ] )

Parameters

dataSourceName$

String. Optional. The name of the data source. Defaults to the current data source.

String. Optional. The name of the user ID.

String. Optional. The password for the user ID.

tableArray

Array of strings. Each element in the array is the name of an available table in a data source.

Not connected to a data source (DBstsNCON)

Unable to get user ID and password (DBstsACCS)

Events

BeforeListTables

AfterListTables

Example
See Also

ListFields method

Glossary