Weird issue in Access 2003

[Chungalin]

Hello,

I've found a quite disturbing issue in Access 2003 with MSDE2000A. I've find out the shortest way to reproduce it:

1) Create a blank ADP file creating a new database in SQL server.
2) Create two tables:

tbl_Test1
  test1_Id, INT, PRIMARYKEY
  test1_LinkId, INT  (this is a foreign key to tbl_Test2)
  test1_Memo, NTEXT

tbl_Test2
  test2_Id, INT, PRIMARYKEY
  test2_Name, VARCHAR(50)

3) Enter a few sample data on both tables, including some links between them through LinkId
4) Create the following query:

SELECT test1_Id, test1_Memo, test2_Name
FROM tbl_Test2 RIGHT OUTER JOIN tbl_Test1
ON tbl_Test2.test2_Id = tbl_Test1.test1_LinkId

5) Now comes the stunning part. Save and run the query, and in the resulting grid try to change the text of any "test1_Memo" cell WITHOUT ALTERING THE PREVIOUS TEXT LENGTH. For instance, "Sample data" -> "Sample date". When this condition is met, THE WHOLE TEXT IS DELETED.

This is not a display issue, I've used SQL Profiler to see that Access actualy sends an "UPDATE..." SQL statement assigning an empty string to that field (so it's neither an SQL server issue). I haven't tried on Access 2000.

The issue disappears by removing the "test2_Name" field from the query, but this is not an acceptable solution for me.

Any help appreciated,
Marti

 

[modest]

After speaking with an associate of mine, he has inferred that this is probably a bug. Additionally, he suggests that you "submit it as a bug to the Access team"

I know this doesn't help, but 2003 may just need a patch.