I am having a very strange problem:
I get the message: "ActiveX component can't create object" after the command:
Set WK = DBEngine.Worksp aces(0)
I have a previous declaration
Public WK As Workspace
Now here is the strange bit - this works without problems except when I run as Administrator - that's when I get the above message.
I've re-registering as Administrator the relevant file "DAO350.DLL " (on the target PC) in the Microsoft Shared folder - and it was successful, but still no change with the outcome.
I'm using VB6 on Win7 for development and can't simulate the problem. This shows up on other PCs running Win7 and Win8.
I get the message: "ActiveX component can't create object" after the command:
Set WK = DBEngine.Worksp aces(0)
I have a previous declaration
Public WK As Workspace
Now here is the strange bit - this works without problems except when I run as Administrator - that's when I get the above message.
I've re-registering as Administrator the relevant file "DAO350.DLL " (on the target PC) in the Microsoft Shared folder - and it was successful, but still no change with the outcome.
I'm using VB6 on Win7 for development and can't simulate the problem. This shows up on other PCs running Win7 and Win8.