[AccessD] Value Truncated in Access Link to SQL Server Table

hmmmm interesting, I have sql server 2008 express and MS Access 2002,
created a test table in SQL with a field of decimal(18,6), entered the
value 0.07125 which showed in SQL as 0.071250 linked the table to Access
opened it and saw 0.07125......


On 1 July 2013 14:46, Dan Waters <df.waters at comcast.net> wrote:

> The problem was that I only got 2 decimal places instead of the 5 I needed.
> I was pretty surprised that a Decimal type in SQL Server couldn't be
> completely understood in an Access table link.  I'm going to guess that
> there is something in the ODBC link which is insufficient for a SQL Server
> decimal type.
>
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland
> Sent: Monday, July 01, 2013 8:24 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Value Truncated in Access Link to SQL Server Table
>
> In the past I have also used the decimal field type so you should be able
> to
> have decimal(18, 6) as well as a float type
>
>
> On 1 July 2013 14:08, Dan Waters <df.waters at comcast.net> wrote:
>
> > What I needed to do was to use the Float data type in SQL Server.
> > Then the ODBC table link in Access would see the entire value.
> >
> > Dan
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> > Sent: Saturday, June 29, 2013 12:24 PM
> > To: 'Access Developers discussion and problem solving'
> > Subject: [AccessD] Value Truncated in Access Link to SQL Server Table
> >
> > Hello!
> >
> >
> >
> > I have a table in SQL Server which has a field named SalesTaxRate.
> > This field has a type of Numeric(18,6).  The value I entered is
> > 0.07125, and it displays in SQL Server as 0.071250 which is correct.
> >
> >
> >
> > But when I open the ODBC link to this table in Access, the value shows
> > as .07.
> >
> >
> >
> > I've tried using a Decimal field, changing the precision and scale
> > values, and re-creating the table link.  All to no avail.
> >
> >
> >
> > Anyone know how to fix this?
> >
> >
> >
> > Thanks!
> >
> > Dan
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com