BUG: Extra Spaces Added to Fields When Updating MS Access Table (196711)

MORE INFORMATION

Steps to Reproduce Behavior

1. Using Microsoft Access create a database that has a table with the following structure:

         Field Name      Field Type
         --------------------------
   
         ID              AutoNumber
         Fld1            Text(10)
         Fld2            Text(10)
   						

   Add some records to the table and then exit Microsoft Access.
2. Using the ODBC Manager, create an ODBC DataSource to the Microsoft Access table based on the Microsoft Access ODBC driver.
3. In Visual FoxPro, open a database and create a Remote View to the Microsoft Access table using the data source created in the step 2.
4. In the Visual FoxPro View Designer dialog box, choose the Fields tab and then select all of the fields. Click the Update Criteria tab, and then select ID as the key and set all the fields as updateable. Select the "Send SQL Update" option. Save and then close the view.
5. Open the view and add a record to it as follows:

         USE View1
         INSERT INTO View1 VALUES(7,'aaa','aaa')

6. Exit Visual FoxPro and then run Microsoft Access.
7. View the table in Microsoft Access, and select either fld1 or fld2 in a record you added from Visual FoxPro.