Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    Office XP Pro?
    a2k (9.0.3821) SR-1 Jet 4.0

    In a previous post I asked:

    I develop in A2k, Customer has Office XP Pro installed

    Question:

    1. Can I continue to develop in A2k, deliver by modem front-end db and convert to Office XP Pro for
    distribution and use on their client computers?

    Hans replied:

    Access 2002 (XP) can work with Access 2000 databases without any conversion - in fact, the A2000 format is the default database format in A2002.

    So you can keep on developing in Access 2000, and you don't need to convert the frontend or the backend for distribution. You won't be able to use any of the new features in Access 2002, but that has the advantage that you'll be able to use the databases in a mixed 2000/2002 environment.

    New question:

    If the end user is using their client Access 2002 (XP) with database format in A2002 for their miscellaneous use, can I install my A2k front end A2k back end and tell Access 2002 (XP) to open my apps in A2000 format? Is there a Application.SetOption that will tell access which format to use? Or does this happen automatically?

    Thanks, John

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

    Re: Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    Access 2002 has an option to set the default file format for NEW databases, but regardless of this setting, it can open EXISTING databases in 2000 and in 2002 format without conversions or special settings.

    So unless you want to your app to create a new database and want to make sure that it is in Access 2000 format, there is no need to get or set the default file format.

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

    Re: Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    As Hans says, the file format (2000 or 2002) is a property of the file. If you have the default set to 2002 and you open a 2000 format database, it stays in 2000 format. There is no conversion going on. What you have to watch out for is where you create a new database and import the objects from the 2000 format. In that case, the new database will be in whatever format is set as the default, not in the format of the original.
    Charlotte

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    Hi Charlotte

    Where and how to you set the default format?

    John

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

    Re: Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    Have you looked at the Advanced tab on Tools / Options?
    Wendell

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    Hi Wendell

    I don't have the Office XP Pro product yet, but it looks like I have to open a db after install then make my default format decision based on your previous post.

    Thanks, John

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

    Re: Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    Nope - by default XP sets the file format to 2000 when you install it. Only if you change it to 2002 will it then switch to making 2002 format databases (until you change it back to 2000). I've only created one 2002 database in two years, though others (Charlotte at least) make a front-end in 2002 and the back-end in 2000. In my view there are only a few special case situations where 2002 is a compelling choice.
    Wendell

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

    Re: Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)

    It's reasonably compelling for the front end if you want to use any new XP features, although there aren't many of them. I'm doing it this way because I wasn't given a choice by my boss. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    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
  •