Set appAccess = CreateObject('Access.Application')Р”Р„fter you create a new instance of the Application class, you can open a database or create a new database by using either the OpenCurrentDatabase method or the NewCurrentDatabase method. From Visual Basic, first create a reference to the Access object library, and then create a new instance of the Application class and point an object variable to it, as in the following example: Dim appAccess As New Access.ApplicationР”Р‡rom applications that don't support the New keyword, you can create a new instance of the Application class by using the CreateObject function: Dim appAccess As Object You can open an Access database from Visual Basic and work with its objects. To do this, you use the Application object.Р”Р‡or example, Microsoft Visual Basic is a COM component. You can manipulate Access objects from another application that also supports Automation.

Application.SetOption 'Show Status Bar', TrueР”Р„ccess is a COM component that supports Automation, formerly called OLE Automation. The following example shows how you can set the Display Status Bar check box on the Current Database tab of the Access Options dialog box. For example, you can use the SetOption method of the Application object to set database options from Visual Basic. Use the Application object to apply methods or property settings to the entire Access application. The Application object contains all Access objects and collections. The Application object refers to the active Microsoft Access application.

Visual basic for applications access