Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conversion to Access XP from Acc 97 (Windows XP)

    I am about to convert two application from 97 to XP. I would like to convert the data structure to 2000, not XP. Do you agree with that? Where do I specify the option to convert to the 2000 structure? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion to Access XP from Acc 97 (Windows XP)

    At the moment, there are few compelling reasons, if any, to use Access 2002 format, so I agree with converting to Access 2000 format.

    If you open an Access 97 database in Access 2002, you get a choice if and how you want to convert it. But some people have reported problems with converted databases; they recommend creating a blank new database in Access 2002, and importing all database objects from the Access 97 database into it. You can set the default format for new databases (Access 2000 or Access 2002) in Tools/Options..., Advanced tab.

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

    Re: Conversion to Access XP from Acc 97 (Windows XP)

    To get a 2000 format, you have to make sure Access XP is set to that default file format in the Tools-->Options-->Advanced tab. Since 2000 is the default for Access 2002, you shouldn't have a problem there. There are apparently some serious bloat issues with the 2002 format where the file just keeps growing and compacting the database does not get you back to a reasonable size. I haven't seen that personally, but there are articles in the knowledgebase on the problem.
    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
  •