I have an Access 2002 mdb front end linking via DSN to SQL Server backend. When i enter values into a currency field via the front end they are not saved in the SQL Server back end. I can manually enter them into the tables in SQL Server and they are visible in SQL Server, but when I open the linked table in Access, the fields appear blank. It must be an error with DSN or ODBC but I don't know what to do about it. Can anyone help me please?
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.