This can be done using ADO objects. The methods and properties are well documented.

Access databases are probably the easiest to use with ADO. Most, if not all, of the properties and methods will be supported.