Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Talking Unanswered: time converting 97-00 access

    Fellow programmers, survivors of H1B and Outsourcing, please try to give me an estimate of how long it would take to migrate an average size Access 97 MDB file to version 2000. I need to give enough time for testing etc. Monday I start, and there will later be dozens more to migrate. Just need a 'ballpark' for each on average. Thanks guys.

    Michael.Lynn@princetoninformation.com

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    That depends ... Is this 97 DB just data? Or does it have reports, forms, and queries also?

  3. #3
    Join Date
    Dec 2003
    Posts
    3

    time to migrate

    Originally posted by M Owen
    That depends ... Is this 97 DB just data? Or does it have reports, forms, and queries also?
    It has everything: tables(data, relationships),queries,forms,macros,reports,module s

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    There really is no way to give an "average" ... Data, queries, and tables are straight forward ... It's the forms and reports that are killers ... Those depend on how many and more importantly how complex they are ...

  5. #5
    Join Date
    Oct 2003
    Posts
    706

    Talking

    Too bad you aren't using a system like Paradox, in which the various versions are quietly, seamlessly, forward and backward compatible. . .

    Obviously, such a project ought to be "the work of a morning," no big deal, drop-dead-simple. Obviously there is no good reason on this little green earth why it should possibly be otherwise; anything less.

    In your case, you simply must purcha$e the late$t ver$ion of Micro$oft Office, spend your time rolling the application forward to the late$t and greate$t, and know that when you are fini$hed, you and your cu$tomer can never go back!

    But, this is "the devil you know" and this is what you will be required to do, basically at your own expense, just to keep Bill Gates' daughter in (4,000 square foot) play-houses...

    Sorry.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  6. #6
    Join Date
    Nov 2003
    Posts
    267
    One thing to look at is that your DAO code will not work with the conversion. You will need to declare you DAO recordsets as

    Dim rs as DAO.recordset -- instead of Dim rs as recordset

    in Access 2000

    You will get a better Idea of who long it will take you after your finish your first DB, then rest should follow a similar patteren (plus there is a learning curve)

    S-

Posting Permissions

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