help with c/ odbc

hi, i try to connect to navision from vb, but it sends an error message …“table doesn´t exists”…can someone help me? Private Sub Command1_Click() Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset conn.Open “nav” Set rs = conn.Execute(“Select * from Panteones”) MsgBox (rs.RecordCount) End Sub

Table and field names are case sensitive. Also, because VB does not allow you to use UNICODE characters in the source code, you can’t select a table this way. VB has ChrW(&H1234) function for UNICODE characters, but I am not sure if that is the problem you are experiencing. See here for the full list: http://www.unicode.org/charts/ Note that SQL keywords like SELECT and FROM are not case sensitive. Another suggestion, you may not be accessing the same database as the one that has the table above. Check “nav” to see what database it’s pointing at.