T
Tomasz J
Hello Developers,
ADP form bound to a simple view (single table with unique index, no TOP N
statement) is not updatable in Access 2003. In Access 2000 it worked just
fine.
Here is what I found: in Access 2003 "Unique Rows" form recordset property
is FALSE while the same property is TRUE when the same project is opened
with Access 2000.
What seems to cause the difference is the DataProvider -
Microsoft.Access.OLEDB.10.0
Since this provider must be used in Access 2003 (KB 281784 and 281998) I see
no way to accomplish my goal - have editable forms bound to a simple SQL
Server view.
Effectively, this problem prevents my client from migrating to from Access
2000 to some newer version without a major remake. Database stores very
sensitive data and for security resons views filtering records must be used.
I just cannot believe such issue slept through the regression testing
process. Also, I found no publication discussion this problem.
Any help appreciated.
Thomas J
ADP form bound to a simple view (single table with unique index, no TOP N
statement) is not updatable in Access 2003. In Access 2000 it worked just
fine.
Here is what I found: in Access 2003 "Unique Rows" form recordset property
is FALSE while the same property is TRUE when the same project is opened
with Access 2000.
What seems to cause the difference is the DataProvider -
Microsoft.Access.OLEDB.10.0
Since this provider must be used in Access 2003 (KB 281784 and 281998) I see
no way to accomplish my goal - have editable forms bound to a simple SQL
Server view.
Effectively, this problem prevents my client from migrating to from Access
2000 to some newer version without a major remake. Database stores very
sensitive data and for security resons views filtering records must be used.
I just cannot believe such issue slept through the regression testing
process. Also, I found no publication discussion this problem.
Any help appreciated.
Thomas J