While updating a string value with single quote (') in access datbase some of the data's gets truncated? For example:
insert into testtable values( 'Ram's', 25, 'IServ' );
Above said query, updates only the following value: R,25,IServ
insert into testtable values( 'Ram's', 25, 'IServ' );
Above said query, updates only the following value: R,25,IServ
