Post reply

Cant store values in money fields

  • February 6, 2009 at 6:38 am

    #199686

    I have an Access 2003 mdb front end linking via DSN to SQL Server 2005 Express backend. When i enter values 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?

  • February 6, 2009 at 12:33 pm

    #939740

    Did you refresh the linked table after changing it on the SQL with 'Linked Table Manager' in your Access FE?

    --AL

  • February 6, 2009 at 1:25 pm

    #939765

    Yes and I have recreated the link from scratch. When I type a value into a currency/money field in the Access linked table it disappears as soon as I go to another record.

  • February 6, 2009 at 2:45 pm

    #939812

    Found this on another forum .. might it be your problem:

    Solved!!! I kept on digging for answer and found a guy with the same problem: "In case anyone else may hit the same problem, Ingres Corp identified the cause of the problem as in version 3.50 of the Ingres ODBC driver, and have issued patch 11389 which resolves the issue.

    The patch can be obtained by request from Ingres or via their ftp site.

    Best Regards,

    Phil "

    So you have to download it at:

    http://download.openlinksw.com/downl...m=5&fam=1&df=6

    The above download link no longeer seems to work - here is the link for the forum that discusses the problem

    http://www.access-programmers.co.uk/forums/showthread.php?t=143832

    Another link discussing the same problem:

    When linking a SQL server 2000 table to Access 2003 using the standard MS

    ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney

    are blank in Access.

    If I use a DataDirect ODBC driver the money fields are displayed correctly.

    From this link:

    http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.odbc/2006-03/msg00021.html

    Hope this helps - let us all know if it does

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 11, 2009 at 3:35 pm

    #942537

    I downloaded and installed the ODBC driver from openlinksw.com and it works. Thank you. Just surprised that Microsoft have not released a fix.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply