Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conversion from A2k2 to A2k (A2k2 SP2)

    Hi All,
    I'm running into an error trying to convert a previously converted A2k db to A2k2 back to A2k. (Yeah, I know it sounds strange, but I do what I gotta do.) Anyway, the converting progress bar (in the Status Bar) gets to about two-thirds the way through and an error message pops up (see attachment).
    My concerns:

    <UL><LI>There are no reports in this db
    <LI>There are no Macros in this db and therefore cannot enter the *correct* report name
    <LI>No Action Failed dialog box is displayed
    <LI>Once OK is clicked the Converting progress bar does not disappear when the conversion is finished (if it even *is* finished)
    <LI>No Property Sheet has that report name either[/list]Any idea where and/or why this error occurs? and what does it mean? and is there a conversion error? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Everything *seems* to be working when opened on a machine which has A2k (and not A2k2) loaded but I haven't had the time to be able to check it out thoroughly as the conversion had to be done on the fly to be used during spring semester registration, which is now.
    Is this "just one o' those things" or is this something that can cause this db to <img src=/S/toilet.gif border=0 alt=toilet width=24 height=26>
    Thank you.

    gdr
    Attached Images Attached Images
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

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

    Re: Conversion from A2k2 to A2k (A2k2 SP2)

    Hi Gary,
    Try importing all of the objects from the 2002 database into an empty 2000 format database - if that works then there's something strange going on with the conversion process. If it doesn't, you probably have some sort of corruption in the 2002 database. I presume the database is really a 2002 format, not just a database created in 2000 and looked at with 2002. (2000 format is the default format for Access 2002.)
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion from A2k2 to A2k (A2k2 SP2)

    Hi Wendell,
    Your presumption is corrrect. Actually this db was originally developed in A97, converted to A2k and then to A2k2 and now back to A2k and I'm certain it will have to go back to A2k2 (probably just because of the strange way academics are <img src=/S/smile.gif border=0 alt=smile width=15 height=15> ) once registration is over. The people who are using this db have WinXP and OffXP on their office machines but the machines they are using during registration, are Win2k and Off2k. And yup, I know that this could have been avoided if they had left the db as A2k, but............ <img src=/S/boxedin.gif border=0 alt=boxedin width=25 height=20>
    So, I just imported the objects into a blank A2k db with no problems and things seem to be in order. I also did a conversion on another db which I had converted from A2k to A2k2 earlier and had no problems converting it back into A2k. So that means, to me anyway, that it is something intrinsic in the first db I converted. In looking further, however, I cannot find any differences between the 2 db's (1 with the error and the other which went smoothly) which were converted, as far as references or properties or anything else that I know how to check.
    So I guess I'll just have to monitor the *error_on_conversion* db and see if in fact there has been a conversion problem.
    Thank you.

    gdr
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

Posting Permissions

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