2012

Table Of Contents
2 Do one of the following:
To open a database table in Read-only mode, click DbConnect
menu View Data View External Table.
To open a database table in Edit mode, click DbConnect menu
View Data Edit External Table.
If required by the database to which you are connecting, you are prompted
to enter a valid user name and password.
3 In the Select Data Object dialog box, navigate to and select the database
table you want to open. Click OK.
NOTE Some database systems require that you obtain access privileges before
you can view or edit database tables. Refer to the documentation for your database
system, or check with your database administrator.
To open a database table directly from the Data Sources node of the
dbConnect Manager
Double-click a database table in the dbConnect Manager.
By default, double-clicked database tables are opened in Edit mode. You
can change the default double-click behavior to Read-only mode, if desired.
To change the double-click open setting for database tables
1 Click Tools menu Options.
2 On the System tab, select Open Tables in Read-only Mode.
3 Click OK.
To move a column in a database table
1 Click the column header of the column that you want to move.
2 Click the column header again and drag it to the desired location.
To resize a column in a database table
1 In the Data View window, select the grid line at the right border of the
column header of the column you want to resize.
2 Drag to the right to enlarge the column, or to the left to shrink it.
2010 | Chapter 39 Access External Databases