The functions and statements you can use with data access are:
BeginTrans Statement
CommitTrans Statement
CompactDatabase Statement
CreateDatabase Function
FreeLocks Statement
OpenDatabase Function
Partition Function
RegisterDatabase Statement
RepairDatabase Statement
Rollback Statement
SetDataAccessOption Statement
SetDefaultWorkspace Statement
The methods you can use with data access objects and controls are:
AddNew Method
Append Method
AppendChunk Method
BeginTrans Method
Close Method
CommitTrans Method
CreateDynaset Method
CreateQueryDef Method
CreateSnapshot Method
Delete Method
DeleteQueryDef Method
Edit Method
Execute Method
FieldSize Method
FindFirst, FindLast, FindNext, FindPrevious Methods
GetChunk Method
ListFields Method
ListIndexes Method
ListParameters Method
ListTables Method
MoveFirst, MoveLast, MoveNext, MovePrevious Methods
OpenQueryDef Method
OpenTable Method
Refresh Method
Rollback Method
Seek Method
Update Method
UpdateControls Method
UpdateRecord Method