harmmeijer
Programmer
I am using an odbc data source to link a sql table to access.
A field wich is ntext in sql is interpreted as a text field in access (not as memo)... WHY WHY WHY!!!!
ntext and text are the longest text fields in SQL server like the memo in access, using forms in access this gives errors when you try to change a record.
When I change the field in SQL (since I cannot change anything in the way access interperets the SQL fields) to varchar with a length of 8000 everything works fine.
Is this a bug of some sorts??? Why doesn't access (97) interperet the ntext and or text field as memo so the forms work ok when you try to update(=change) a record??
There is yet another problem, when I open the form wich has the record source from the linked table it gives an odbc--call failed (without any error numbers or help) and all my fields are filled with the o so familiar value #Name?.
The strangest thing is I can update and insert records as long as I do not stay in one record for more than 10 seconds.
Opening the linked table gives me the same error directly and all fields are filled with the value #Name?
I am using the sql server driver version 3.70.09.61
A field wich is ntext in sql is interpreted as a text field in access (not as memo)... WHY WHY WHY!!!!
ntext and text are the longest text fields in SQL server like the memo in access, using forms in access this gives errors when you try to change a record.
When I change the field in SQL (since I cannot change anything in the way access interperets the SQL fields) to varchar with a length of 8000 everything works fine.
Is this a bug of some sorts??? Why doesn't access (97) interperet the ntext and or text field as memo so the forms work ok when you try to update(=change) a record??
There is yet another problem, when I open the form wich has the record source from the linked table it gives an odbc--call failed (without any error numbers or help) and all my fields are filled with the o so familiar value #Name?.
The strangest thing is I can update and insert records as long as I do not stay in one record for more than 10 seconds.
Opening the linked table gives me the same error directly and all fields are filled with the value #Name?
I am using the sql server driver version 3.70.09.61
