Results 1 to 4 of 4

Thread: Please Advise!

  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Question Unanswered: Please Advise!

    Hi I am upgrading a database from 97 to 2002, I just wanted some advice. Has anyone done this before and it worked out okay? I just was worried about all the code was developed in 97 and will that port over okay to 2002?

    Any feedback gratefully recieved!

    Thanks Ed

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    Quote Originally Posted by Nixies
    Hi I am upgrading a database from 97 to 2002, I just wanted some advice. Has anyone done this before and it worked out okay? I just was worried about all the code was developed in 97 and will that port over okay to 2002?

    Any feedback gratefully recieved!

    Thanks Ed
    Just make sure of the "dot" and "hash" fix if you know what I mean.

  3. #3
    Join Date
    Jul 2003
    Posts
    100
    Sorry I don't, what is the 'dot and 'hash' fix?

  4. #4
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Access 97 to Access XP (2002)

    I've done this with very large databases and there are issues.

    I the database is very large and complex some code will corrupt. One way round this is to create a blank XP databae and import everything into it. If you have a pericularly large module you might even consider using cut and paste to get it into XP!

    The references to DAO have to be set in XP they're not there by default, if you use this type of code don't forget to set the refernces to it.

    If you're trying to create mailmerge by controlling Word from Access it gets worse....

Posting Permissions

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