连接 (ADO/WFC 语法)

适用于：Access 2013 | Access 2016

包 com.ms.wfc.data

无。

public Invalid DDUE based on source, error:link not allowed in code, link filename:mdobjconnection_HV10294216.xml() 
public Connection(String connectionstring ) 

方法

public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthbegintrans_HV10294108.xml() 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthbegintrans_HV10294108.xml() 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthbegintrans_HV10294108.xml() 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthadocancel_HV10294125.xml() 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthclose_HV10294173.xml() 
public com.ms.wfc.data.Recordset Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthcnnexecute_HV10294345.xml(String commandText ) 
public com.ms.wfc.data.Recordset execute(String commandText , int options ) 
public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthcnnexecute_HV10294345.xml(String commandText ) 
public int executeUpdate(String commandText , int options ) 

executeUpdate 方法是一个特例方法，它用某些参数调用基础 ADO execute 方法。 executeUpdate 方法不支持返回 Recordset 对象，因此，execute 方法的 options 参数可以用 AdoEnums.ExecuteOptions.NORECORDS 进行修改。 在 execute 方法完成之后，其经过更新的 RecordsAffected 参数会传回给 executeUpdate 方法，executeUpdate 方法最终会以 int 形式返回。

public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthcnnopen_HV10294563.xml() 
public void open(String connectionString ) 
public void open(String connectionString , String userID ) 
public void open(String connectionString , String userID , String password ) 
public void open(String connectionString , String userID , String password , int options ) 
public Recordset Invalid DDUE based on source, error:link not allowed in code, link filename:mdmthopenschema_HV10294568.xml(int schema, Object[] 
 restrictions , String schemaID ) 
public Recordset openSchema(int schema) 
public Recordset openSchema(int schema, Object[] restrictions ) 

属性

public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdproattributes_HV10294098.xml() 
public void setAttributes(int attr ) 
public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdprocommandtimeout_HV10294196.xml() 
public void setCommandTimeout(int timeout ) 
public String Invalid DDUE based on source, error:link not allowed in code, link filename:mdproconnectionstring_HV10294218.xml() 
public void setConnectionString(String con ) 
public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdproconnectiontimeout_HV10294222.xml() 
public void setConnectionTimeout(int timeout ) 
public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdprocursorlocation_HV10294254.xml() 
public void setCursorLocation(int cursorLoc ) 
public String Invalid DDUE based on source, error:link not allowed in code, link filename:mdprodefaultdatabase_HV10294288.xml() 
public void setDefaultDatabase(String db ) 
public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdproisolationlevel_HV10294459.xml() 
public void setIsolationLevel(int level ) 
public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdpromode_HV10294518.xml() 
public void setMode(int mode ) 
public String Invalid DDUE based on source, error:link not allowed in code, link filename:mdproprovider_HV10294673.xml() 
public void setProvider(String provider ) 
public int Invalid DDUE based on source, error:link not allowed in code, link filename:mdprostate_HV10294804.xml() 
public String Invalid DDUE based on source, error:link not allowed in code, link filename:mdproversion_HV10294926.xml() 
public AdoProperties Invalid DDUE based on source, error:link not allowed in code, link filename:mdcolproperties_HV10294633.xml() 
public com.ms.wfc.data.Errors Invalid DDUE based on source, error:link not allowed in code, link filename:mdcolerrors_HV10294338.xml() 

事件

有关 ADO/WFC 事件的详细信息，请参阅 ADO 事件实例化（按语言）。

public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtbegintranscomplete_HV10294112.xml(ConnectionEventHandler handler ) 
public void removeOnBeginTransComplete(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtbegintranscomplete_HV10294112.xml(ConnectionEventHandler handler ) 
public void removeOnCommitTransComplete(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtconnectconnectionevents_HV10294210.xml(ConnectionEventHandler handler ) 
public void removeOnConnectComplete(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtconnectconnectionevents_HV10294210.xml(ConnectionEventHandler handler ) 
public void removeOnDisconnect(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtexecutecomplete_HV10294351.xml(ConnectionEventHandler handler ) 
public void removeOnExecuteComplete(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtinfomessage_HV10294445.xml(ConnectionEventHandler handler ) 
public void removeOnInfoMessage(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtbegintranscomplete_HV10294112.xml(ConnectionEventHandler handler ) 
public void removeOnRollbackTransComplete(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtwillconnectevent_HV10294953.xml(ConnectionEventHandler handler ) 
public void removeOnWillConnect(ConnectionEventHandler handler ) 
public void Invalid DDUE based on source, error:link not allowed in code, link filename:mdevtwillexecuteevent_HV10294954.xml(ConnectionEventHandler handler ) 
public void removeOnWillExecute(ConnectionEventHandler handler ) 

另请参阅

• 访问开发人员论坛
• 访问 support.office.com 上的帮助
• 访问 answers.microsoft.com 上的帮助
• 访问 UtterAccess 上的论坛
• 访问开发人员和 VBA 编程帮助中心 (FMS)
• 访问 StackOverflow 上的帖子

支持和反馈

有关于 Office VBA 或本文档的疑问或反馈？ 请参阅 Office VBA 支持和反馈，获取有关如何接收支持和提供反馈的指南。