hello, i'm working with an external database via automation, the code goes quite like this example:
'Declaration of variable in a module.
Public app1 As Access.Application
...
'and then this in a sub()
Set app1 = CreateObject("Access.Application")...