February 6, 2009 at 6:38 am
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
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
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
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
February 11, 2009 at 3:35 pm
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