Databases Method

Provides access to the Databases collection of the Workspace object.

Applies to objects: Workspace

Syntax

[[Set] RetVal = ] object.Databases ()

The Databases method syntax has these parts:

Part Description
object Required. A reference to an instance of the object.
RetVal Optional. A Databases type variable.

Example

' Declare and initialize variables
Dim engine As DBEngine Set engine = new DBEngine Dim wspace As Workspaces Set wspace = engine.CreateWorkspace("MyWorkspace") ' Open database Dim dbase As Database Set dbase = wspace.OpenDatabase("MyDatabase", 0, false, "ODBC; UID=mylogin; PWD=mypassword; DSN=SQLBaseDSN") '... ' Get the Databases collection Dim dbcoll As Databases Set dbcoll = wspace.Databases() '...

 

See Also

Database Object, Databases Object, Workspace Object.