VAccess Data Source

VAccess Data Source

The VAccess control is the data source control. It provides database communication with the source code of an application and data transfer to the other eight bound controls and to third-party controls.

The VAccess control is visible at design time as an icon, but is not visible at run time.

Each VAccess control references one table in a database at a time. The control is connected to a database in one of two ways:

•

by setting the DdfPath property of the control to the location of the data dictionary files (FILE.DDF, FIELD.DDF, and INDEX.DDF) which define the database. The VAccess control requires DDF files for its database definition at design time. The record source for the control is specified by setting the TableName property to the name of one of the tables in the data dictionary. The physical operating system path to the database file is specified by the Location property, which defaults to the table location defined in the DDF when TableName is chosen..

•

by setting the HostAddress property of the control to the name of a machine and the DatabaseName property to a database name on that machine. Choose the table using the TableName property

The OwnerName property allows you to specify an owner name if one is required for opening the table.

Record navigation properties and methods and field access properties provide record data in code. The data source can also be bound to the other controls provided or to third-party data controls that operate as bound controls in Visual Basic.

Custom Properties, Events, and Methods

Custom properties, events, and methods for this control are listed in the following tables in alphabetical order. For lists of custom properties, methods, and events by category, see the chapter Properties, Methods, and Events By Category.

The lists of properties does not include stock properties such as (About), (Custom), (Name), Index, Left, Tag, and Top.

Table 7

VAccess Custom Properties

DdfKeyUseIndexDDFOnly

Selected Fields

DdfTransactionMode

SelectedRecords

RefreshLocations

Table 8

VAccess Custom Methods

DdfGetFieldComments

ShowSelectedFieldsDlg

DdfModifyLocation

ShowSelectedRecordsDlg

DdfModifyTableName

GetNextExtended

DdfTestOwnerName

GetPreviousExtended

FormatFieldValue

GetTotalSegments

DdfAddTableName

StepNextExtended

DdfClearIndexes

StepPreviousExtended

DdfCreateDictionary

GetGreaterOrEqual

DdfDropIndexMaintain

Table 9

VAccess Custom Events