Results 1 to 8 of 8
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't open form after conversion 2K => 97 (97)

    I have had this problem occasionally.

    One potential reason is the presence of ActiveX controls (i.e. controls that are not native to Access, such as the Calendar control, the TreeView control, etc.) Could you check in Access 2002 whether this is the case?

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

    Can't open form after conversion 2K => 97 (97)

    <P ID="edit" class=small>(Edited by hasse on 21-Apr-04 14:54. Added what I've already tried to solve the problem)</P>Valuable members of this board,

    in a (backwards)converted database Access 97 refuses to open a form which opened willingly in Access XP.

    The error message is one of the more informative MS produces but unfortunately couldn't make my day (translation from Dutch...):
    Can't open file file name
    It contains data that aren't recognised by Microsoft Access
    Create the form again or get a backup copy of the form (this is only possible if you have made a backup copy of the database).

    Any idea about the possible cause of this behaviour?

    Original file format: "Access 2000 file format"
    Access version used for conversion: Access XP (no SR installed)
    Previously I've converted a number of similar databases without any problems. I can ask the client to send a new copy but as it opens perfectly in XP, I doubt whether this would solve the problem...

    Already tried without success:
    - try again
    - compact and repair in XP & in 97
    - rename form: it contained a number of spaces and another form's name started exactly the same, which might have confused Access (would be weird though),
    - conversion from newly created file in XP in which I had imported objects from original database

    TIA!
    Hasse

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

    Re: Can't open form after conversion 2K => 97 (97)

    Hans,
    where can I see which ActiveX-controls are used in a database?
    The closest I can get is comparing the references used (VBA window - option menu) and there everything seems OK:

    <table border=1><td>Reference</td><td>XP name</td><td>XP source file</td><td>97 name</td><td>97 source file</td><td>VBA</td><td>Visual Basic for Applications</td><td>VBE6.dll</td><td>idem</td><td>VBA332.dll</td><td>Access</td><td>Microsoft Access 10.0 Object Library</td><td>msacc.olb</td><td>Microsoft Access 8.0 Object Library</td><td>msacc8.olb</td><td>ADO</td><td>Microsoft ActiveX Data Objects 2.1 Library</td><td>msado21.tlb</td><td>idem</td><td>msado15.dll</td><td>OLE</td><td>STDOLE2.olb</td><td>idem</td><td>idem</td><td>row5-col5</td></table>

    FYI: I know *nothing* about ActiveX-controls
    (and for once, this isn't something I'm not really ashamed of: I've always avoided them whenever possible (having already plenty of adventure trying to tame Access alone), considering them as things from 'outer space' which often aren't readily & certainly available at other user's desktops - afraid to 'dive into the cold water' probably <img src=/S/grin.gif border=0 alt=grin width=15 height=15>)

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

    Re: Can't open form after conversion 2K => 97 (97)

    You would have to check the form for non-standard controls. It doesn't seem very likely that you'll find one, however, for inserting an ActiveX control usually sets a reference to the corresponding file.

    You can also check if the form has a linked background picture, or an image control with a linked picture. The picture file might be missing. (This should not cause the problem you mention, but ...)

    Something else you could try (work with copies of the original):
    - Delete the problem form from the converted database, then try to import it from the original database.
    - Remove some elements from the form in the copy of the original database, then convert to Access 97. See if you can open the form now.

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't open form after conversion 2K => 97 (97)

    Didn't the ADO library "start" with Access 2000, and was not present in Access 97?
    thx,
    Pat (hesitatingly and unsure ....)

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

    SOLVED Re: Can't open form after conversion 2K=>97

    First, thanks for your time & suggestions:
    - Pat: the ADO reference isn't indicated as 'not found' in the reference dialog and in VBA, you can Dim ... as ADODB... so I think ADO is available in Access 97. I tried unchecking it (don't remember before and after conversion though), but it didn't make a difference;
    - HansV: importing objects into Access 97 from the original 2K/XP file won't work: non-recognised database format
    - HansV: remove some elements...: put me in the right direction! <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

    IT'S SOLVED!!!!

    However: I dunno why... Maybe it was one of those small details you don't think of mentioning. However, I prefer suspecting those <img src=/w3timages/censored.gif alt=censored border=0> gremlins <img src=/S/alien.gif border=0 alt=alien width=14 height=15> <img src=/S/devil.gif border=0 alt=devil width=15 height=15> <img src=/S/invisible.gif border=0 alt=invisible width=15 height=15> <img src=/S/pirate.gif border=0 alt=pirate width=22 height=18> <img src=/S/witch.gif border=0 alt=witch width=15 height=15> from deep down in the MS Access caves you get delivered for free with the package. Redmond, you made me (and those wanting to help) loose valuable time (again)!
    (Still it's a good lesson: I had to be wiser <img src=/S/bash.gif border=0 alt=bash width=35 height=39>, make a pdf-print from XP, leave and let be and head to the next one...)

    FYI, what did I do:
    - I deleted the (two) page break controls, 'honouring' them as the most 'uncommon' controls I could find besides the labels, text & combo boxes making up the other probably 100+ controls on the form; (I tabbed all around the form to be sure I didn't miss any)
    - conversion => no error!
    - reproduction phase (checking: <font face="EraserDust">Are thou page breaks true spoilers of MS fun?</font face=dust>): I started from the original file / copied it to my portable / converted it once / deleted the page breaks / converted it again / copied the results to my desktop / opened both files (simultaneously) and ... both opened without an error!

    Thanks for your time - Hasse

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

    Re: Can't open form after conversion 2K => 97 (97)

    You can use ADO with Access 97, but there are a lot of things not supported or not fully supported. Built-in support for ADO objects and providers came with Access 2000 and later.
    Charlotte

  8. #8
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't open form after conversion 2K => 97 (97)

    Ah -- thank you !
    Pat

Posting Permissions

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