DLOOK UP Error "The MS Office Access database engine cannot find the input table etc. (1 Viewer)

Hudas

Registered User.
Local time
Today, 15:33
Joined
May 13, 2013
Messages
55
DLOOK UP Error "The MS Office Access database engine cannot find the input table etc.

Hi -

I have multiple database opened

I have a macro in outlook linked to ms access... I have a DLookup that looks up the name of the assigned agent based on the table vendor assignment using the sender email address. The problem is whenever the macro run in outlook it gives me this error "The MS Office Access database engine cannot find the input table or query 'tbl_vEndor_aSsignment'. Make sure it exists and that its name is spelled correctly."

The error is not on the database that I'm using where the 'tbl_vEndor_aSsignment' but instead on another databse.


Code:
Set ws = DBEngine.Workspaces(0)
Set acAppdB = ws.OpenDatabase("P:\pHarMaGMBdatabaSe.accdb")

AssignedTo is a text.

Code:
straSsignedTo = DLookup("[AssignedTo]", "tbl_vEndor_aSsignment", "[eMailAdress] = '" & mItem.SenderEmailAddress & "'")

Can anyone give me an idea on what im doing wrong ?
 

Users who are viewing this thread

Top Bottom