Results 1 to 4 of 4
  1. #1
    Enrightt is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Posts
    10

    ODBC Connection is Changing My Data Type

    Hey Guys,

    I've been setting up an ODBC connection to a table housed on a SQL server. I have a field in the table that contains a percentage value formated as decimal(10,4).

    However, when I set up the ODBC connection in Access, it shows up as Currency and rounds off the value. I've tried numeric(10,4) and adding decimal spaces.

    Any idea why this is happening? I've done this hundreds of times before and never seen this.

    Thanks!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Currency *IS* (10,4). Rounding is a Formatting issue. Where are you looking at the value? In a query, table, form?

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    access doesnt have decimal type.
    as RuralGuy said currency is the equivalent.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    SQL Server Express DOES have a field type of DECIMAL(18,0)

    You DON"T "...set up the ODBC connection in Access...". You LINK Access to the SQL instance (tables/views) USING the ODBC connection.

    As RG asked "Where are you looking at the value? In a query, table, form? ".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 04-25-2018, 10:32 AM
  2. Replies: 8
    Last Post: 09-27-2012, 08:23 AM
  3. Changing SQL user pw causes ODBC connection issues
    By EEALLPARTS in forum Security
    Replies: 0
    Last Post: 02-28-2012, 11:54 AM
  4. Replies: 3
    Last Post: 01-06-2012, 04:17 PM
  5. Replies: 5
    Last Post: 10-25-2011, 08:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums