Hello,

I hope this is the right group to post to.

I'm trying to have a VB6 application create an Access.Application (Office10)
object through late binding (CreateObject), which opens an MDE database.
The Access code will then create an Excel.Application (again through late
binding; GetObject).

However, when the Access application tries to create the Excel application,
I get the following error: ActiveX Component Can't Create Object

This error does not occur if I open the Access file directly, not through
VB6.

Right now I'm having the VB6 application create a shell which call the
Access database, but I'm very uncomfortable about hard-coding the entire
path-to-msaccess.exe in my application.

Do VB6 or VBA have an object-depth limit of one? Or, any ideas what could
be wrong?

Thanks,
Bryon

Archived from group: microsoft>public>vb>ole