Using the Database Description Window |
The Database Description window is used to establish a connection to and display attributes of an external database. This information can then be used when configuring the Data control, DataGrid control or calling database actions/methods. Simple ViewWhen viewing information about a database, the Simple view provides the basic information required to use the database. This includes the Connection String, Server and Source settings and the field names and types. Advanced ViewThe Advanced view will also display extra information about the database. The extra information includes details on what features are supported by this database. Connection TabThe Connection tab displays information about the database connection used to open the database. In Simple view this includes the connection string and the server type. In Advanced view it also includes information about features supported by the database such as Transactions. Recordset TabThe Recordset tab displays information about the recordset created by this database connection. In Simple view this includes the database source and information about each field in the recordset. In Advanced view it also displays information about the features supported by the recordset such as whether updates and deletions are allowed. TIP!The recordset tab will only be populated if you specify a table in the Source field of the Database Description window. See AlsoData Access | Using the Database Description window to connect to a database |
|