Access function problems

[labanTek]

Hi can you tell me why the following code does not open my database? I placed this code in the Onclick event of a command button.
Thanks in advance.

Dim myAccess As Access.Application
Set myAccess = CreateObject(, "Access.Application")
myAccess.OpenCurrentDatabase ("C:\koykoy.mdb")

 

[RoyVidar]

Probably that you try to pass the path as the second arguement to the CreateObject function. The class is supposed to be the first arguement (which is more like how you'd use the GetObject function, I think).

[tt]Set myAccess = CreateObject("Access.Application")[/tt]

Roy-Vidar