I have just joined the Forum today, I wish firstly taking this opportunity to say Hello to everyone.Secondly thanks in advance for your helps.
I am having problem in editing/appending data to fields stored in SQL table. I use MS Access as the front end with ODBC linked to these table for Edit. Datatype conversion problem arises for Char and varchar SQL-datatype.Insert key has to be used for each field that need to be appended with characters.
Access form does not use or bring over the field length specifed in SQL table and seem to set the length of text field to a variable value that matching the length of text currently present in the SQL field being read.(Different SQL record has different content for a particular field (fix length char), but Access just uses the length of the content in this field as the maximum field length)
To append more character to the end of existing data, I have to press 'Insert' key then I can append new characters. Not doing so the field is locked with the existing amount of data in that field (a beep sound comes off Access every time I tries to add more characters to this field, eventhough it is not full yet), I must delete some character first before typing in new characters.
And I have to press Insert key for each field that I want to edit/append extra characters to avoid this problem
Would you please help me out, if there is a way that I do not need to press Insert key before appending more character to the field, that way it would be more user friendly, since they can open Access form and edit data stored on SQL database right away.
many thanks in advance.
I am having problem in editing/appending data to fields stored in SQL table. I use MS Access as the front end with ODBC linked to these table for Edit. Datatype conversion problem arises for Char and varchar SQL-datatype.Insert key has to be used for each field that need to be appended with characters.
Access form does not use or bring over the field length specifed in SQL table and seem to set the length of text field to a variable value that matching the length of text currently present in the SQL field being read.(Different SQL record has different content for a particular field (fix length char), but Access just uses the length of the content in this field as the maximum field length)
To append more character to the end of existing data, I have to press 'Insert' key then I can append new characters. Not doing so the field is locked with the existing amount of data in that field (a beep sound comes off Access every time I tries to add more characters to this field, eventhough it is not full yet), I must delete some character first before typing in new characters.
And I have to press Insert key for each field that I want to edit/append extra characters to avoid this problem
Would you please help me out, if there is a way that I do not need to press Insert key before appending more character to the field, that way it would be more user friendly, since they can open Access form and edit data stored on SQL database right away.
many thanks in advance.
