Access / SQL Server currency datatypes
This is a discussion on Access / SQL Server currency datatypes within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> When linking a SQL server 2000 table to Access 2003 using the standard MS ODBC driver (2000.85.1117.00) fields with ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 10:08 PM
| ||||
| ||||
 Access / SQL Server currency datatypes 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. Any Idea if there is a MS ODBC driver that displays money correctly?      |
|
02-27-2008, 10:08 PM
| ||||
| ||||
| Re: Access / SQL Server currency datatypes You might want to ask this question in one of the Access newsgroups since it isn't an ODBC or a SQL Server issue. Someone there may have the answer you seek. --Mary On Tue, 14 Mar 2006 06:02:26 -0600, "Simon Lampert"<ureader@byteaccess.com> wrote: >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. > >Any Idea if there is a MS ODBC driver that displays money correctly? |
 |
« NEWBE
|
MySQL Linked Server »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:59 AM.
