I need to edit some MS SQL data and used an ACCESS project to do it. The data was in a view, and the editing went fine.
When i ran the application i got inconsistent results.
Looking at the data in MSSQL SMS i noted a difference between records i entered through ACCESS and other records: The ACCESS entered records contained NULL for empty fields. Other records had empty fields (necessary for the application) but did not show the NULL value.
The fields in question are varchars.
What causes the different presentation in SMS, and how can I make ACCESS create acceptable values?