Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting: Invalid Field Type (Access 2002)

    Hi All!

    I'm running in a dual environment. Ick. My database was created in 97, then upsized to 2002--originally. For the past few weeks, I have been modifying it in 2002 and downsizing it to 97, quite successfully. But today I get this error while converting to 97:

    "Invalid Field Data Type"

    This error is preventing the conversion. Only problem is, when I look through all of my tables, there are no invalid field types. There are also no warning signals as to what might possibly be causing the error.

    Has anyone seen this before? Any ideas?

    Cecilia :-)

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Converting: Invalid Field Type (Access 2002)

    I've not seen that behavior, though I have seen weird things doing design work in Access 2002 and then trying to run it in 2000. I would suggest that you always upsize to 2002, make your changes, and then downsize to 97, rather than working with a 2002 version. Which raises the point of what kind of database you have - is it 2000 or 2002? If it's the latter, that could be a problem. Also, if you have a record that uses a UniCode character that would cause grief in either 2000 or 2002. Just some shots in the dark - hope it helps.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting: Invalid Field Type (Access 2002)

    Hi Wendell,

    I'm working with 2002 and 97; we skipped 2000 altogether, so I am particularly careful to use only 2002 and 97 versions.

    I am doing all my design work in 2002. When I'm done, I'm downsizing to 97. Since I don't know 2002 really well, it's unlikely that I'm using anything that 97 doesn't understand.

    How can I tell if I have a unicode character?

    Cecilia

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Converting: Invalid Field Type (Access 2002)

    The only way I can think of to find out who/what the culprit is is to export objects one-by-one to an empty Access97 database. It will be tedious, but that should tell you which object is the culprit. If it's a table with unicode, that should cause it to fail too - I should have asked if you database is split into a front-end and back-end arrangement - if not you will want to do that so you don't have to convert data each time <img src=/S/question.gif border=0 alt=question width=15 height=15> If it's is already split then unicode in a table shouldn't be the problem.
    Wendell

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting: Invalid Field Type (Access 2002)

    Hmmm. Already tried that. Still the error. Guess it must be something in a table. Does anyone know if there is something that generally causes these errors? A quote perhaps? Or some other symbol?

    Thanks, Wendell.

    Cecilia :-)

  6. #6
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting: Invalid Field Type (Access 2002)

    I have a very dull, distant bell ringing about Yes/No fields and this type of problem with imports. Have you got any of them? I cannot remember any details unfortunately. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Converting: Invalid Field Type (Access 2002)

    It might be quiet too late but you never know...
    I got the same error, due to a numeric - decimal field type. After I changed it to Double, the problem was solved.

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

    Re: Converting: Invalid Field Type (Access 2002)

    You shouldn't need a double for much of anything and the floating point numbers can cause you grief if you're looking for exact values. A Currency format is usually a better choice unless you need more than 4 decimal place precision, in which case you have to either live with floating point creep or develop a workaround using long integers.
    Charlotte

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Thanks! (nt) - Re: Converting: Invalid Field...

    <P ID="nt"><font size=-1>(No Text)</font>

Posting Permissions

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