Results 1 to 4 of 4

Thread: "Invalid field data type." when converting to prior version of MS Access.

  1. #1
    Guest

    Angry

    I'm developing a website that uses a MS Access database. I'm creating the database in Access 2000, but the web server can only open Access 97 databases. I've been using the "Convert Database -> To prior Access Version" for the web server to use, and it's been working fine.

    I just added a new table to the database containing the following fields:

    ID - AutoNumber, Long Integer, Autoincrement, Primary Key, Not required, Indexed (No duplicates)
    paragragh - Memo, Not required, Zero length allowed, Unicode Compression
    picture - Text, Max 50, Not required, Zero length allowed, Not indexed, Unicode Compression
    picturealignment - Text, Max 5, Not required, Zero length allowed, Not indexed, Unicode Compression
    fonttags - Text, Max 100, Not required, Zero length allowed, Not indexed, Unicode Compression

    Now when I try to convert it to an Access 97 database I get a

    "Invalid field data type."

    first, followed by

    "Some errors happened during the conversion. No converted database is generated."

    Can anyone help me?

  2. #2
    New Member
    Join Date
    Aug 2010
    Posts
    1

    Re: "Invalid field data type." when converting to prior version of MS Access.

    I'm having an identical problem.
    Was a solution found?
    Can you help?

  3. #3
    PowerPoster
    Join Date
    Jul 2006
    Location
    Maldon, Essex. UK
    Posts
    6,334

    Re: "Invalid field data type." when converting to prior version of MS Access.

    You do realise that this thread is over 10 years old don't you?

  4. #4
    Lively Member
    Join Date
    Aug 2010
    Posts
    76

    Re: "Invalid field data type." when converting to prior version of MS Access.

    10 years and no answer for this guy
    i hope the answer was found elsewhere

Posting Permissions

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



Click Here to Expand Forum to Full Width