hi, I got problem accessing views in Visual Basic 6. Dim rsSchedule As New Recordset With rsSchedule.Open "SELECT * FROM tvwClassSchedules", dbConn, adOpenDynamic, adLockReadOnly
.Close End With I got this error: ERROR: relation "tvwClassSchedules" does not exist; Error while executing the querythis view exist because i can use the view in pgAdmin to display the records.
please help. thank you, ocavid