Hey PetergUK,

You can add a reference to Access in VB under the Project/References... menu. Just select the Microsoft Access 8.0 Object Library, and then you should be able to do most things you can do in Access straight from VB. You can use the DoCmd.RunMacro method to run a macro.

I want to be able to print Access reports from within VB, and you can do that this way. However, nobody's been able to tell me you can do this on a machine that does not have Access (or Office at all) installed on it. Anyone? Will the install for the VB app put the necessary files onto a non-Access machine? Thanks.

-JoeyCode