Posted on 1998-01-09
Setup: SQL Server 6.5. Client- MS Access 2.0 ODBC driver version 1.02.3231 (comes with Access). The problem I have is: I have a SQL table vith ,say char(10) column. When I attach this table in Access, text entered in character field is padded with spaces (eg. instead of 'aaa' i would have 'aaa ' so in order to insert or add something to the end I have to remove spaces and then type. I belive it has something to do with ANSI padding setting in SQL server, so how do i configure it?