Results 1 to 10 of 10
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Access vs DB3 (all)

    I'm being asked to look at an application written in DB3 (haven't seen it yet). I've never worked with DB3. But I can't help wondering why build in DB3, when you have Access?

    Any comments...
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Access vs DB3 (all)

    I'm with you on that one Catharine. BTW how old is DB3 anyway? Is it still supported?

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

    Re: Access vs DB3 (all)

    Maybe they are looking at upgrading it to Access? I would certainly suggest that - unless it turns out to be DB2 which could be the IBM product that's more like Oracle or SQL Server.
    Wendell

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Access vs DB3 (all)

    Embarrassing, I don't have a clue who made DB3 or 2.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Access vs DB3 (all)

    Catherine:

    DB3 PROBABLY refers to dBase III, which was developed by Ashton-Tate many years ago. It was/is an Xbase database and was followed by dBase IV, etc, etc.

    Access will read dBase III files more or less successfullyy, although I've had to open them first in Excel, then import them into Access on occasion.

    I'm sure there are a bunch more of the database "oldtimerrs" that can give you more info if you need it, but trying to do further development in dBase III would be an exercise in futility.

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Access vs DB3 (all)

    Thanks, with that lead I was able to track down some current product info here. I'm still interested in what people with experience with this product have to say though!

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  7. #7
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Access vs DB3 (all)

    I'm thinking/hoping that it won't be that. I mean, I hope that I can look like a genius <img src=/S/grin.gif border=0 alt=grin width=15 height=15> for bringing a DB forward into Access.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Access vs DB3 (all)

    If it is dBase 3 then there is reasonable support for it in Access, but I would recreate the tables in Access rather than trying to link to them with ODBC or the ISAM driver. There are serious performance hits in doing the latter. In addition, each table for dBase is in it's own file, as are indexes also if I recall correctly. There are also some constraints in dBase tables that don't exist in Access. So I predict you will be the hero for at least a day. And I'm sure you can get lots of help here if you need it.
    Wendell

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

    Re: Access vs DB3 (all)

    Catherine,

    If you're lucky, it will be dBase III+. As Wendell noted, the indexes are separate files and life got more complicated in dBase 4 and later. dBase III files open nicely in Excel, although you can usually import them into Access as long as the dBase ISAMS are installed on your machine. I programmed extensively in dBase III until Access occurred, but I haven't touched it in years.
    Charlotte

  10. #10
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Access vs DB3 (all)

    I should find out in a day or two - then the questions will really start! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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