Access
For MS Access the Data source properties dialog permits the .MDB file containing the database to be selected using the Browse button
A user id and password may be entered into the relevant boxes if required, otherwise the User ID box should be left blank
Once the Connection string is complete the connection may be tested by pushing the Test connection button.
To complete the dialog a “query” is required to determine what data to retrieve from the database. Frequently this will be the all the content of a specific table or Access Query. For example the string:
SELECT * FROM Products
returns all the data from the Products table, including the fieldnames.