Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Anderson, Indiana
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC Connection (Access 2002)

    <img src=/S/confused.gif border=0 alt=confused width=15 height=20> I am not sure where to post this, so I will try here first. I am using an ODBC gateway to my inhouse data processing system to gather data into MS Access. There are some fields that do not show up in my linked tables. If I use MS Query (via Excel) they are visible. Help!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ODBC Connection (Access 2002)

    What do you mean by an "ODBC gateway" and what are the characteristics of those fields that don't show up in Access but do show up in Excel?
    Charlotte

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Anderson, Indiana
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Connection (Access 2002)

    Our data processing vendor provides an ODBC "Gateway" ( third party ODBC driver) that connects to their data files. A rough count shows 260 of approx. 320 fields are visible. I have not isolated exactly which fields are missing or their types.. What characteristics are you asking about?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ODBC Connection (Access 2002)

    If you are using the same ODBC driver from both Access and MSQuery, then I'm at a loss to suggest why you might see more fields one way than the other unless the fields you don't see are those that Access can't handle because they are not data types it recognizes. Are you creating linked tables against the data using their ODBC driver?
    Charlotte

  5. #5
    New Lounger
    Join Date
    Mar 2002
    Location
    Anderson, Indiana
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Connection (Access 2002)

    Yes, I am using linked tables. As to the types of fields, I know that the one missing field is type number with a length of two. Is there a limitation on the number of fields in an access table? Could this be the issue?

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ODBC Connection (Access 2002)

    Actually, there is a limitation on the number of fields, but I didn't pick up on the fact that you meant all the fields were in one table. An Access table can only have 255 fields, so when you said you got 260 of 320, I assumed you were not talking about a single table. In any case, that limitation is probably what is causing you grief in this case.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •