最近透過ADO的Recordset Object和Command Object去存取資料庫的資料，發現這兩個物件都有Properties可以設定，並且分成Connection Object、Command and Recordset Object、Table Object、Column Object、Index Object來介紹，下面的表格列了幾個Properties作參考！

Property Name	Description
Cache Authorization	A Boolean value (read-only) that indicates whether the data source is allowed to cache sensitive authentication information, such as a password, in an internal cache. For the Microsoft Jet provider, this value is always True.
Encrypt Password	A Boolean value (read-only) that indicates whether the password can be sent without encryption. For the Microsoft Jet provider, this value is always False.
Mask Password	A Boolean value (read-only) that indicates whether the consumer requires that the password be sent to the data source in a masked form.
Password	A String value (read/write) that specifies the password to be used when connecting to the data source.
Persist Encrypted	A Boolean value (read-only) that indicates whether the data source object saves sensitive authentication information in an encrypted format. For the Microsoft Jet provider, this value is always False (no encryption).
Persist Security Info	A Boolean value (read-only) that indicates whether the data source object can save sensitive authentication information. For the Microsoft Jet provider, this value is always False.
User ID	A String value (read/write) that specifies the user ID to be used when connecting to the data source.
Asynchronous Processing	A Long value (read/write). Not supported by the Microsoft Jet provider.
Data Source	A String value (read/write) that specifies the name of the data source. Typically this consists of the path and file name of the data source.
Window Handle	A Long value (read/write) that specifies the window handle to be used if the data source object needs to prompt the user for additional information.
Locale Identifier	A Long value (read/write) that specifies the locale ID (LCID) to use when opening a database. The LCID specifies the database's collating order, which is the character set that will be used to determine how values in the database are sorted. This property does not guarantee that all text returned to the consumer will be translated according to the LCID. The Locale Identifier property can also be used to specify the LCID when you create a new database by using the Create method of the ADOX Catalog object. See Locale Identifier Property Settings later in this document for a listing of the values that can be assigned.
Mode	A Long value (read/write) that specifies a bitmask that indicates access permissions. When read from the Properties collection, the value returned is a number. When using the Mode property of the Connection object, you can use built-in constants, such as adModeRead. The Mode property can be one of the following values: Read-only (adModeRead) 1 Write (adModeWrite) 2 Read/Write (adModeReadWrite) 3 Share Deny Read (adModeShareDenyRead) (Prevents others from opening in read mode.) 4 Share Deny Write (adModeShareDenyWrite) (Prevents others from opening in write mode.) 8 Share Deny Exclusive (adModeShareDenyExclusive) (Prevents others from opening in read/write mode.) 12 Share Deny None (adModeShareDenyNone) (Neither read nor write access is denied to others.) 16
Prompt	A Long value (read/write) that specifies whether to prompt the user for connection information during initialization. The Prompt property can be one of the following constants: Prompt Always (adPromptAlways) (Always prompt the user for initialization information.) 1 Prompt Complete (adPromptComplete) (Prompt the user only if more information is needed.) 2 Prompt Complete Required (adPromptCompleteRequired) (Prompts the user only if more information is needed. Doesn't allow the user to enter optional information.) 3 Prompt Never (adPromptNever) (Don't prompt the user.) 4
Extended Properties	A String value (read/write) that specifies a string that contains provider-specific connection information that can't be explicitly described through standard ADO properties. For the Microsoft Jet provider, this property is used to pass the Microsoft Jet connection string for opening or creating databases of other file formats. For information about settings, see Extended Properties Property Settings later in this document.

ADO Provider Properties and Settings
http://msdn2.microsoft.com/en-us/library/aa140022.aspx