From that message I realise that there is no "lcmdb" table or query in this MDB. Are you shure that a table with this name exists in this MDB?
Try this after you crate a connection to MDB
lcmdb=("c:\HJSDB.mdb")
Store SQLSTRINGCONNECT(;
'DBQ='+lcmdb+';'+;
'Driver={Microsoft Access Driver (*.mdb)}');
TO gnConnHandle
If gnConnHandle <= 0
= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
Return
Endif
IF SQLTABLES(gnConnHandle,"TABLE","myCursor") == 1
SELECT myCursor
BROWSE NORMAL
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.