I found the problem.....

The user "Languaje" parameter were set different in test database, I changed to "English" and now everything works fine...

Thanks everybody....

First, thanks all for your coments...

I have reviewed the table definitions and they are the same.

SQLBill you were right i'm using SQL 2000

I don't think there is a length problem...

Hi..!!!

Maybe you can make the ODBC uses an SQL Server "User_id" with read rights only, then the linked tables on access will read data but it could not write back.

I...