Page 1 of 2 12 LastLast
Results 1 to 15 of 28
  1. #1
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Free replacement program for Microsoft Access

    I use Microsoft Access only for one database (which people here actually created for me a long time ago):

    http://students.hamilton.edu/2005/jrick/quotesfacts.mdb

    This seems silly -- especially since I'm considering upgrading to Office 2003 from 2002, and in so doing downgradng from Office Pro, which includes Access, to Office Standard, which excludes Access -- and so I'm curious if there's a free program out there that will allow me to create a similar database?

    Thanks a lot.

  2. #2
    4 Star Lounger
    Join Date
    Oct 2001
    Location
    Bellevue, Nebraska, USA
    Posts
    569
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Free replacement program for Microsoft Access

    Don't know of a replacement but just in case you are not aware, when you upgrade to Office 2003 from Office 2002 Pro, your Access 2002 will remain in place and usable. I am in the exact same situation as you. I have one database in Access (my 600+ music CD collection) - When I installed Office 2003, the install program did not touch my 2002 Access.
    Bill (AFE7Ret)
    Freedom is NOT Free!
    Heat is the bane of all electronics!

    ─────────────────────

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Free replacement program for Microsoft Access

    I found this <img src=/S/free.gif border=0 alt=free width=30 height=15>ware application - haven't tried it, but might fit the bill:

    9-September-2000 size: 969kb
    myMDB is a client for Microsoft Jet Databases (*.mdb) and requires the free MDAC 2.1 components from Microsoft. Features: auto-form, form designer, html-reports with print preview, integral html-viewer, integral syntax highlighted SQL and HTML editor, integral SQL tutorial, execute SQL statements, sample JanSoft database.

    Alan

  4. #4
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Re: Free replacement program for Microsoft Access

    Thanks for the sug.

    myMDB sounds like what Jayden described in http://www.wopr.com/cgi-bin/w3t/showthread...vc=1#Post410393

    I'd prefer, however, to stear clear of Access.

  5. #5
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Re: Free replacement program for Microsoft Access

    Thanks, but I'd like to abandon Access.

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Free replacement program for Microsoft Access

    Can you set out a list of requirements? There may be some type of "information organizer" or PIM that's suitable (many free) but need to know the details of how you want it to work.

    Alan

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Free replacement program for Microsoft Access

    I know that StarOffice has a database component, but that's not free, and actually, I've never used it. I do not think that Open Office (the free version) has a database component. At least, mine doesn't.

    You could look into converting your tables to MySQL tables. But then you would have to get some other product(s) to write all your reports and input forms.

  8. #8
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Re: Free replacement program for Microsoft Access

    <P ID="edit" class=small>(Edited by Jon_Rick on 23-Sep-04 12:59. )</P>The quotesfacts database I'm using is simply an ever-growing collection of bon mots that interest me.

    Accordingly, I need fields only for the quote, the source, the quotee, and categories.

    Theoretically, I could use Excel, but I prefer the look and feel of a database program.

    The simpler, the better.

    Thanks a lot.

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Free replacement program for Microsoft Access

    These aren't free, but only ASKSAM is more than $50 US or so, and they might work for your purpose:

    http://www.softcircuits.com/snippets/

    http://www.bitsmithsoft.com/

    http://www.whizfolders.com/

    http://www.asksam.com/
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Tampa, Florida, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Free replacement program for Microsoft Access

    My 2 pennies worth...... Have you considered using OpenOffice? It has the same features as Office, can read just about any file type, has data base tools, and is FREE.

    Go to OpenOffice1.1.3 <img src=/S/free.gif border=0 alt=free width=30 height=15>

  11. #11
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Re: Free replacement program for Microsoft Access

    Thanks, but I'm very happy with Microsoft Office.

  12. #12
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Free replacement program for Microsoft Access

    > Theoretically, I could use Excel, but I prefer the look and feel of a database program.

    Which part of the look and feel? Access kind of looks like Excel until you design a form... if you have the energy to learn a little VBA, you can create a UserForm in a friendly host (e.g., Word or Excel) that interacts with your MDB file using those MDAC components someone mentioned in an earlier post.

  13. #13
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Free replacement program for Microsoft Access

    Hi Jon

    I have made an assumption that the DB programme in works is a stripped down version but I have not used it, I have made the assumption because the spreadsheet programme that ships with works is a stripped down version of Excel. I am leaving for Holland in about an hour (UK time) so I cannot get back to you before Tuesday, if you want a copy please PM me your address and I will post it off.

    PS. watch out Hans if I am in Holland you can bet I will have a suitcase load of questions !!


    Stephen

  14. #14
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Free replacement program for Microsoft Access

    You can't actually send people components of the Microsoft Works program, I'm pretty sure that would violate the license. Anyway, I believe the database is quite a different format; there have been requests posts over the years asking for converters for Word databases.

  15. #15
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Free replacement program for Microsoft Access

    I would suggest getting Office 2003 Pro.
    It is worth having Access as one cannot forecast when one will need to use the critter.

Page 1 of 2 12 LastLast

Posting Permissions

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