C
Chungalin
Hello, I've found a quite disturbing issue in Access 2003 projects with
MSDE2000A. I've find out the shortest way to reproduce it:
1) Create a blank ADP project 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 funny 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 this on Access
2000.
The issue disappears by removing the "test2_Name" field from the query, but
this is not an acceptable solution to me.
Any feedback appreciated, thanks
MSDE2000A. I've find out the shortest way to reproduce it:
1) Create a blank ADP project 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 funny 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 this on Access
2000.
The issue disappears by removing the "test2_Name" field from the query, but
this is not an acceptable solution to me.
Any feedback appreciated, thanks