Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Aug 2001
    Location
    Chewelah, Washington, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DOS Access to newer Access program (Access 2002)

    I request guidance on the best way to help a group convert an old DOS Access database to either Access 2000 or 2002. The group uses an old DOS Access version 1 or 2 to run a program to match presenters with attendees for an Expanding Your Horizon event. During the last event in September, the database crashed in the middle of matching girls with each seminar and created serious problems. The group would like to upgrade the database. I have available Access 2000 at home and 2002 at work. Unfortunately, I am just a beginner and many of your threads have me lost. I plan on getting a copy of the database and either getting help from more experienced Access programmers a friend works with or seeking help through Woody Watch. I haven't seen the database and need an idea on what to get copies of when I pick it up. What would you need to see if someone brought you a database to convert? Thank you.

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

    Re: DOS Access to newer Access program (Access 2002)

    There was *never* a DOS version of Access, so either the old database isn't Access or it wasn't written for DOS. Was this a runtime version of Access? Otherwise, they must have the Access application on their machine and you can find out for certain what version it was.

    Assume the worst. Get copies of all reports generated by the current database and samples of all documents (even if they're on the backs of envelopes <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) that act as source documents for the existing system. Get any documentation they have on the old database, including any user manuals. Ask *lots* of questions and don't ever assume they've given you the right answer.
    Charlotte

  3. #3
    Lounger
    Join Date
    Aug 2001
    Location
    Chewelah, Washington, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DOS Access to newer Access program (Access 2002)

    Thank you. The person with the events planning task just took over the job and knows nothing about databases. I'll pick up the database after the first of the year and will ask more questions then. Thanks again.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: DOS Access to newer Access program (Access 2002)

    Just a couple of watch our fors in addition to Charlotte's post:

    There have been so many functional changes and improvements in Access since 2.0 (or 1.x) that I would recommend a total rewrite rather than trying to do an upgrade. In addition, the skill level of people has upgraded considerably since 1994 when Access 2 was released, so the design of the old DB is probably suspect. Thus Charlotte's suggestion that you look at the inputs and the outputs and design from there is spot on.

    The other issue is the possibility that the database has been secured, especially if it was a commercialized application. To determine that, find out if any sort of login prompt is issued when you start the database. If there is, it may make salvaging the data from the application considerably more difficult. I'm sure folks here would be happy to help you sort through that situation if you have to.
    Wendell

  5. #5
    Lounger
    Join Date
    Aug 2001
    Location
    Chewelah, Washington, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DOS Access to newer Access program (Access 2002)

    Thanks again. Charlotte has commented many times about the differences in versions, so a rewrite seemed to be the only way to go. The person who wrote the database was very involved in EYH for several years and I figure they would have a much better appreciation of the different problems that can crop up in running a once a year program with up to 2000 participants. With both inputs, I should be able to pick up all the data and examples I need to start this project. Thank you.

Posting Permissions

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