This component provides the facility to set up a connection to a database.
Click the dieresis to open the ADO connection dialogue. For an Access database choose 'Use Connection String' from the options on the first part of the ADO set up dialogue; from the second part of the ADO set up routine choose 'Microsoft Jet 4.0 OLE DB 4.0'; in the third part of the set up routine click on the dieresis for option 1 of the connection (in diagram below) and locate the database; click the Test Connection button to confirm that the link works (it will fail if you have left the database open).
This is set to true when the other properties are set.
The cursor in ADO describes the way data is accessed. The two types of cursor are Server and Client. When the cursor is on the server data are obtained from the server and when it is on the client the data source is on the client computer.
This is set to False to remove the need to supply a user name and password to the database; set to false to provide basic security.