Okay, I finally got this to work, but it took my correcting the name of the Remote View; there were two with similar names and I will have to delete one of them from the project in order to not make this mistake again. YIKES!!!

Here's the code that DID work:

OPEN DATABASE C:\DEV\GETDATA\DATA\EYESCAPE
lnConnHandle=SQLSTRINGCONNECT('DBQ=C:\Program Files\Synemed\EyeScapeNE\esc.mdb;DefaultDir=C:\Program Files\Synemed\EyeScapeNE;Driver={Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS Access;FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\Eyescape.dsn;MaxBufferSize=2048;')

USE RV_PATIENTS IN 0 CONNSTRING lnConnHandle
SELECT RV_PATIENTS
APPEND FROM PATWK