Where are you running the code from -- Access, Excel, or some other app?
And do you need to open the file to manipulate it, to run reports, to return data, ... ?
If, for example, you are using Excel to grab data from Access you can use ADO. There are plenty of examples on the Board.
If I misunderstood, please accept my apologies. But if you give more detail you'll get more useful help.