appaccess.OpenCurrentDatabase

D

DLI

I am trying to use this piece of code in a runtime environment
It opens another database whose name isa determined at runtime from a menu
in a
menu database (compiled mde file)


Line 1: Dim appaccess As Access.Application
Line 2: Set appaccess = New Access.Application

Line 3: Spath = Application.CurrentProject.Path & "\TestDB.mdb"

Line 4: appaccess.OpenCurrentDatabase (spath)


It works fine with Access installed on the machine, but I get an error when
trying to run it on a machine that only has the runtime.

The error occurs in the line 1 and reads

OLE Automation Error

Does anyone have any suggestions as to what is missing from the runtime
installation?

All libraries found in either the menu database and the target database have
been included in the setup program such as MDAC , etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top