Test for value in external database

[esskaykay]

Here I go again, maybe asking for something that’s not possible. What I want to do is test if something exists in another database on the server. I can link the table, however this is on a laptop in the field without a network connection.

Database = f:\sewers\new\portable.mdb
Table = TACTN
Field = SYSTEM

What I tried just as a test was:

If ([SYSTEM] = “SAN” Then
MsgBox “YES”
Else
MsgBox “NOPE”
End if

But I’m getting is “…can’t find the field ‘|’ referred to in your expression”
Any suggestions?

Thanks,
SKK