Accessing another application during run-time

[Shafee]

Or you can use

Dim Acc As Access.Application

You must have Microsoft Access 9.0 Object Library added to your project references.

Sanon, I have seen a lot of you guys using API over this method. What is the advantage of using API for this? (I would like to improve my knowledge)