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")
app1.Application.OpenCurrentDatabase GetThePath()
'where GetThePath() is just a function returning the correct path to the
'.mdb file
End Sub
i know that it was working like this, but now it is not and i dont know why. all it does is an error message saying:
run-time error '-2147417851 (80010105)'
Method 'OpenCurrentDatabase' of object 'Application' failed
can you help me please?
is there any possibility how to find out the more understandable explanation of that error from the number? where can i get the list of objects which can be created by the CreateObject() function and what does it depend on? could my problem be just a problem inside a MS SQL Server? thanx a lot & enjoy a day 
'Declaration of variable in a module.
Public app1 As Access.Application
...
'and then this in a sub()
Set app1 = CreateObject("Access.Application")
app1.Application.OpenCurrentDatabase GetThePath()
'where GetThePath() is just a function returning the correct path to the
'.mdb file
End Sub
i know that it was working like this, but now it is not and i dont know why. all it does is an error message saying:
run-time error '-2147417851 (80010105)'
Method 'OpenCurrentDatabase' of object 'Application' failed
can you help me please?


Last edited: