The settings for this connection level are not overwritten by the ADO Recordset property settings. If you want to edit the data, you must set up the connection string or the ReadOnly setting in the DSN configuration, and the following is a detailed description of the ADO recordset ....
In order to connect to the database server, we must select a database access interface. Although there are many interfaces available for accessing SQL Server from VB, Microsoft's latest database access interface, ADO (Activedataobjects), is undoubtedly the most promising because it provides the possibility for the implementation of browser-based database application systems.
Here are some common functions used for database and its device management.
1. Take the current working database----because administrative tasks generally have to be done in the master library, it is a good idea to save the current library before you perform the task before you switch back.
2. Determine if a database device exists
3. Determine if a virtual device number is occupied: Sqlexistdevicenumber.
4. Find one of the smallest virtual device numbers not yet occupied: Sqlgetunuseddevicenumber.
5. Obtain the Data subdirectory path under the SQL Server installation directory: Sqlgetdatapath.
6. Create a new device: Sqlcreatedevice.
7. Create a new database: SQLCreateDatabase65.
8. Take the database device details: Sqlgetdeviceinfo.
9. Enlarge the size of the database equipment: Sqlexpanddevice.
After a period of operation of database application system, the increase of ADO recordset often requires the database to enlarge, and then the equipment size should be enlarged. Unfortunately, the Diskresize statement requires the size parameter to be the enlarged new dimension, not the size that needs to be increased. Therefore, you must check the original size of the device before you can use the Diskresize statement.