"permission denied" errors with CreateObject (runtime 70)

  • Thread starter Maury Markowitz
  • Start date
M

Maury Markowitz

I'm trying to open Excel from my Access db, and open it on a remote machine.
Here is the entire code...

Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application", "thebox")

"thebox" is the correct name, I can ping it fine.

Note that I am *not* trying to open a file, I'm trying to open the
application itself. Reading over the dox, 70 suggests that it could be a file
error or permissions on the registry. I have tried various settings on the
later, but the dox are extremely unclear on exactly what to do here.

Any ideas?
 
N

Norman Yuan

So you are trying to start Excel on another computer (named as "theBox").
Depending on the network configuration, it is possible the user who is
running the Access app on one computer does not have permission to access
some resources on other computer. Thing like type of network, operation
system, user access permission settings... You can install Excel on the same
computer where the Access app is running to make sure your code itself is OK
( Set xlApp=CreateObject("Excel.Application") ). Once you are certain the
code works OK, then look into the network thing to make sure the user has
the proper permission.
 
Top