Results 1 to 13 of 13

Thread: Ms Access Alternatives?

  1. Jul 8th, 2005, 12:11 PM #1
    Adamas
    Adamas is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2001
    Location
    Canada
    Posts
    86

    Talking Ms Access Alternatives?

    I've Just reinstalled windows and yet I've misplaced my Microsoft Office CD so I cant install Ms Access to edit/view my Databases. Any suggestions on a free program that is good and downloadable?

    Any suggestion would help.

    Thanks.
    Reply With Quote Reply With Quote
  2. Jul 8th, 2005, 01:58 PM #2
    Static
    Static is offline
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Ms Access Alternatives?

    List of Commercial Released free DB's
    http://www.sigmod.org/databaseSoftware/commercial/

    List of "Other" free DB's
    http://www.sigmod.org/databaseSoftware/nonprofit/
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  3. Jul 8th, 2005, 05:52 PM #3
    David.Poundall
    David.Poundall is offline
    Frenzied Member David.Poundall's Avatar
    Join Date
    Sep 2002
    Location
    Robin Hood Land
    Posts
    1,457

    Re: Ms Access Alternatives?

    checkout dbtools in my signature
    David

    Learn the Rules so that you know how to break them properly.

    Printing dll dBTools MZTools Winsock API WinsockVB More Winsock SGrid2 MSChart Mail2Web

    If you have found this thread useful then read this
    Reply With Quote Reply With Quote
  4. Jul 9th, 2005, 08:00 AM #4
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: Ms Access Alternatives?

    Here are three that I use that and they also happen to be free:

    MySQL

    MSDE

    Postgresql
    Last edited by Mark Gambo; Jul 9th, 2005 at 08:09 AM.
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
  6. Nov 15th, 2005, 02:49 PM #5
    anna7
    anna7 is offline
    Hyperactive Member anna7's Avatar
    Join Date
    Sep 2005
    Location
    Catalonia
    Posts
    481

    Re: Ms Access Alternatives?

    are there DB similar a Access? Only DB for one pc.

    mysql, sql server express, ...are client-server.

    regards,

    anna7
    Last edited by anna7; Nov 15th, 2005 at 02:52 PM.
    Reply With Quote Reply With Quote
  7. Nov 15th, 2005, 05:48 PM #6
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Ms Access Alternatives?

    MySql, Sql Server Express, and MSDE can all be installed on a local PC I believe. (Sql Server Express and MSDE are designed for this).
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  8. Nov 16th, 2005, 09:08 AM #7
    Dave Sell
    Dave Sell is offline
    PowerPoster Dave Sell's Avatar
    Join Date
    Mar 2004
    Location
    /dev/null
    Posts
    2,961

    Re: Ms Access Alternatives?

    MSDE is designed for single-user access only?
    Nobody knows what software they want until after you've delivered what they originally asked for.

    Don't solve problems which don't exist.

    "If I had eight hours to cut down a tree, I'd spend six hours sharpening my axe." --- Abraham Lincoln (1809-1865)

    2 idiots don't make a genius.
    Reply With Quote Reply With Quote
  9. Nov 16th, 2005, 09:10 AM #8
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Ms Access Alternatives?

    MDBs are more 'convenient' in that you only need the MDB file and MDAC to be present on the machine, while the other servers need the database engine to be installed.

    If you don't have a lot of data, I'd suggest XML files.
    Reply With Quote Reply With Quote
  11. Nov 16th, 2005, 09:11 AM #9
    Dave Sell
    Dave Sell is offline
    PowerPoster Dave Sell's Avatar
    Join Date
    Mar 2004
    Location
    /dev/null
    Posts
    2,961

    Re: Ms Access Alternatives?

    MSDE uses jet technology? I thought it was a stripped-down SQL server?
    Nobody knows what software they want until after you've delivered what they originally asked for.

    Don't solve problems which don't exist.

    "If I had eight hours to cut down a tree, I'd spend six hours sharpening my axe." --- Abraham Lincoln (1809-1865)

    2 idiots don't make a genius.
    Reply With Quote Reply With Quote
  12. Nov 16th, 2005, 09:29 AM #10
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Ms Access Alternatives?

    Quote Originally Posted by Dave Sell
    MSDE uses jet technology? I thought it was a stripped-down SQL server?
    Yes, SQL Server stripped down. Where does it say it uses Jet technology?
    Reply With Quote Reply With Quote
  13. Nov 16th, 2005, 12:07 PM #11
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Ms Access Alternatives?

    Quote Originally Posted by Dave Sell
    MSDE is designed for single-user access only?
    As mendhak said it is a cut-down version of SQL Server, the number of users is limited, but only 'softly'.

    After more than a certain number of users (I think it is 5 or 8) are connected to the same database, all queries to that database are slowed down, but more people can connect.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  14. Nov 16th, 2005, 12:11 PM #12
    Dave Sell
    Dave Sell is offline
    PowerPoster Dave Sell's Avatar
    Join Date
    Mar 2004
    Location
    /dev/null
    Posts
    2,961

    Re: Ms Access Alternatives?

    That sounds suspiciously like Jet behavior...
    Nobody knows what software they want until after you've delivered what they originally asked for.

    Don't solve problems which don't exist.

    "If I had eight hours to cut down a tree, I'd spend six hours sharpening my axe." --- Abraham Lincoln (1809-1865)

    2 idiots don't make a genius.
    Reply With Quote Reply With Quote
  15. Nov 16th, 2005, 12:27 PM #13
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Ms Access Alternatives?

    Nah, Jet would accidentally trash the database after 5 users (or x hours, or y MB)

    The slowdown in MSDE is entirely planned. As long as you keep below the user limit it is a great piece of kit.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width