I want to access a MS Access database where I can pull information from and display it. The trouble is, I cannot get my code to access it. When I look at my code it just doesn't seem right, too.

where is what I have for access the database:

Dim ws As Workspace
Dim db As Database

Set ws = DBEngine.Worksp ace(0)
Set db = ws.OpenDatabase ("c:\Users\Desk top\folder \master_sample_ database\B518fe b2009")...