1. First, you should include the component "Micrsofost ActiveX Data Objects # Library"  from  Tools > Reference. (# means version number)

2. And then, use the follow code to connect the DB and you can use the data from the assigned DB.
(The following example code I write with Access 2010, also you can write with other Microsoft Office production.)