Open Database - Access

Daisy opens Access databases using a Microsoft ADO connection.

A few tips in setting up an ADO connection and the associated SQL statement that are used to connect to an Access database are listed :-

• Use 'Create' in the Open ADO dialog to setup the ADO connection string.

• This calls a standard Microsoft dialog which has lots of Help available if it is required.

• Use a Provider of 'Microsoft.Jet.OLEDB.4.0' as this is probably the simplest to set up.

• 'Build' and 'View' can be used to generate and test the SQL statement.

• Use all the 'Test' buttons provided frequently!

Click the link below to open an ADO connection as a database.