(Use ADO to connect to the database
Connecting to the ACCESS database ACCESS is a contact-type desktop database management system. It can be used to build small and medium-sized database systems and is widely used. The following describes how to use ADO to connect to the ACCESS database. When connecting to the database, you need to use the Open method of the Connection target. Open a connection to the data source.
Syntax: Connectoin.openConnectionstring,userID,password,openoptions
The parameter table of the Open method is described as follows
parameter
ConnectionString
(Optional) String, including connection information, refer to the (ConnectionSting) property for details on valid tuning
UserID
(optional) string including the username to use when establishing the connection
Password
(optional) string, including the password used to establish the connection
openoptions
(optional) ConnectionEnum value. If the coordination is adConnectoAsync, the connection is opened asynchronously, and a ConnectComplete event will be generated when the connection is available)