Problems trying to query a table by VB 6.0 code

[Guest_imported]

I've just installed SQL Server 2000 in a NT 4.0 computer and importted some tables from a MDB database file. So a creatted a database user and gave him read and write rights.
I wrote a code that make the connection to the database through ODBC. The connection is made successfully, but when I try to generate a recordset from the resulting database object, but the system says me that there's no table with the specified name, nevertheless when I open the database using Access or Visual Data Manager I can see the table i've tried to open latelly, but that programs show me the table names with "dbo." before (Ex: dbo.Posto).
So, I installed the personal version of SQL Server 2000 in a Windows 98 computer, and things went diferent. I could read the specified table, but couldn't write then, even though the user i'm using to join the database has this right.
What can I do to solve that problem ?

 

[tlbroadbent]

1) Make sure the user's default database is the database you created rather than master or another database. You can set the ODBC connection to change the database context if you want to handle it that way.

2) Make sure the table you want to update has a primary key or unique index or timestamp column. The record can't be updated without one of those conditions being true. Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous