Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Location
    Hilo, Hawaii, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access97 conversion to Access2002 (Access2002)

    Can anyone recommend a good reference book that would help me identify potential problems when converting an Access97 database to Access2002? I would like to use it to look up equivalent command between the two versions also. I have several LARGE databases that had to be converted but, now, a lot of my Event Procedures are bombing. Example: I use the statement "DIM variable AS DATABASE" in Access97 but in Access2002 there is no such variable type.
    Any help would be greatly appreciated!!!

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access97 conversion to Access2002 (Access2002)

    Try going into references and setting the DAO 3.6 reference and see if this makes a difference. Go into one of the forms and into the code behind the form and do a compile all.
    If that does not work, I would leave the DAO 3.6 selected in the references and go thru all your code and change all
    :
    Dim xxx as Database
    to:
    Dim xxx as DAO.Database

    The same goes for any recordsets, tabledefs etc you have used.

  3. #3
    New Lounger
    Join Date
    Apr 2004
    Location
    Hilo, Hawaii, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 conversion to Access2002 (Access2002)

    Thank you for the prompt assistance!! I will try it and see. Again, thank you.

  4. #4
    New Lounger
    Join Date
    Apr 2004
    Location
    Hilo, Hawaii, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 conversion to Access2002 (Access2002)

    IT WORKED! I had some other problems but your solution was the key to all of the problems!! Much Mahalo!

Posting Permissions

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