C
Chungalin
Guest
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:
3) Enter a few sample data on both tables, including some links between them through LinkId
4) Create the following query:
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
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:
Code:
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:
Code:
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