appaccess.OpenCurrentDatabase

  • Thread starter Thread starter DLI
  • Start date Start date
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.
 
Back
Top