R
Robert Langen
Hello!
I want to call an Access .mdb application from an Excel macro:
Sub StartAccess()
Dim acApp As Object
Set acApp = CreateObject("Application.Access.10")
acApp.OpenCurrentDatabase ("c:\reports.mdb")
acApp.DoCmd.OpenForm "Schedule"
End Sub
It works when a full Access is installed, but doesn't work with the Access
runtime environment. The following message appears:
License information for the component not found. You don´t have the
permission to use this functionality in the design environment.
Of course it's not possible to design any Access element, such as forms or
reports, in the runtime environment. But I only want to call an existing
..mdb, just like calling a .mde file, where designing forms or reports is not
possible, too.
Robert
I want to call an Access .mdb application from an Excel macro:
Sub StartAccess()
Dim acApp As Object
Set acApp = CreateObject("Application.Access.10")
acApp.OpenCurrentDatabase ("c:\reports.mdb")
acApp.DoCmd.OpenForm "Schedule"
End Sub
It works when a full Access is installed, but doesn't work with the Access
runtime environment. The following message appears:
License information for the component not found. You don´t have the
permission to use this functionality in the design environment.
Of course it's not possible to design any Access element, such as forms or
reports, in the runtime environment. But I only want to call an existing
..mdb, just like calling a .mde file, where designing forms or reports is not
possible, too.
Robert