Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgrade to 2002 (Win ME/Access 97)

    I have read the posts, and thought that I had all bases covered. Wrong! When I try to open the Access 97 database, I get a compile error. I ran a find and replace on the Dim rst As Recordset to be sure that I had added the DAO prefix. The same for Dim As Database. That is OK. Strangely, the application appears to function perfectly under Access 2002. I cannot modify the programs, obviously, but everything functions.

    The references set in 2002 are:
    Visual Basic for Applications
    MS Access 10.0 Obj Lib
    OLE Automation
    MS VB for App Extensibility 5.3.

    The application was developed entirely on the Access 97 machine.

    Can someone point me in the right direction?

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

    Re: Upgrade to 2002 (Win ME/Access 97)

    I doubt that you can run the Access 97 database in A97 with a reference set to the Access 2002 object library. And where is your DAO reference? Without an object model, your DAO code is going to fail, even with the DAO specification in the declarations. By the way, it isn't just Database and Recordset objects you have to specify. You also need to find things like querydefs, parameters, fields, indexes, tabledefs, etc., etc.
    Charlotte

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

    Re: Upgrade to 2002 (Win ME/Access 97)

    I am no longer at the Access 2002 machine, but I am sure that there was a reference to DAO 3.6 maybe? I may be wrong on the version. Regardless, how can the application function without everything being fixed?

    The references set in Access 97 are:
    VB for App
    MS Access 8.0 Obj Lib
    MS DAO 3.51

    Could you give me some examples of statements which must be converted? I have no querydefs, tabledefs, nor indexes referred to in VBA. How about an example of a field that must be converted?

    This is compatibility?

    Thank you for the quick response.

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

    Re: Upgrade to 2002 (Win ME/Access 97)

    Backward compatibility for any app from any vendor I'm familiar with *always* means the same thing--a newer version can read or use older version files. It doesn't mean the older version can read newer files. I'm now thoroughly confused as to which way you're converting this thing. Are you trying to convert an A97 app to A2002 or an A2002 database to A97? I thought you said before that it ran in 2002, so what exactly are you trying to do? If it runs in A2002, why are you trying to make it run in A97 again? What exactly are you trying to do?
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade to 2002 (Win ME/Access 97)

    Your problem is more likely than not the "MS Visual Basic for Applications Extensibility 5.3" reference.

    That particular reference is for working with the VBE in Office 2000 or higher, or any other application that has VBA 6 embeded in it.

    What kind of VBE manipulation are you doing? Because A97 probably won't be able to handle that code, since it's VBA 5.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  6. #6
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade to 2002 (Win ME/Access 97)

    I am converting to Access 2002 from 97. It runs in 97, and it runs in 2002, but with error messages saying that it can't compile.

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

    Re: Upgrade to 2002 (Win ME/Access 97)

    Then I agree with Bryan, it's probably the extensibility library. You normally only need that for a few things you can't get at directly, so if you do use it, you need to use the version compatible with Access 97. I'd try taking it out and seeing if the application will compile in 97. If it doesn't, you can always try putting the VB5 version in, assuming that it is available on that machine.
    Charlotte

  8. #8
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade to 2002 (Win ME/Access 97)

    How do I recognize the VB5 version? I will be back at the Access 2002 machine Tuesday. Let's see what happens.

  9. #9
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade to 2002 (Win ME/Access 97)

    I beleive the Extensibility library for VBA5 is just called

    Microsoft Visual Basic For Applications Extensibility
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

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

    Re: Upgrade to 2002 (Win ME/Access 97)

    The VB5 version is the VBEEXT1.OLB while the VB6 version is VBE6EXT.OLB. Both should be located somewhere in ...Program FilesCommon FilesMicrosoft Shared or its subfolders.
    Charlotte

  11. #11
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade to 2002 (Win ME/Access 97)

    My biggest problem is that I don't know what to expect. Should I be able to copy a 97 db to a 2002 machine and expect it to work without problems? This is a little more complicated because of a language change (English to Spanish versions of Access), but date fomats and currency separators and all of that are the same as in English. Is this more or less complicated than a change to Access 2000?

    Let's see what happens Tuesday when I get back to the 2002 machine.

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

    Re: Upgrade to 2002 (Win ME/Access 97)

    You should be able to make the A97 version work on a 2002 machine, but you'll need to convert the database if you want to make any changes to it on that machine. Access 2002 still supports the code from A97, it's just that there are new functions introducted in A2k that didn't exist in A97, so you can't reliably go the other direction.
    Charlotte

  13. #13
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade to 2002 (Win ME/Access 97)

    I have only Access 97 on my machine, while the Access 2002 is only available at another office. Is it feasible/practical to continue to develop on the Access 97 machine and run it on the Access 2002 on an on-going basis? This means that no modifications to the database would be possible on the 2002 machines, but that is OK. Can you do things like compact the database with tables running in 97 under 2002?

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

    Re: Upgrade to 2002 (Win ME/Access 97)

    If you are planning to attach a 2002 front end to a 97 backend, expect the performance to be miserable. The later versions of Access can handle the 97 back end but they do it very slowly, apparently as a result of the move to unicode in A2k and later. You would be advised to get 2002 for your development machine. I have all three versions on my machine at home and 97 and XP on my machine at work. It takes some effort to make them coexist, but it solves the problem of trying to develop in the wrong version.
    Charlotte

  15. #15
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrade to 2002 (Win ME/Access 97)

    I agree that working in all three versions is the best solution. Could you give me your thoughts on installing all three on my Win ME machine? Problems and pitfalls type of information, please.

Page 1 of 2 12 LastLast

Posting Permissions

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