Page 1 of 2 12 LastLast
Results 1 to 15 of 18

Thread: Downgrading

  1. #1
    New Lounger
    Join Date
    Oct 2014
    Posts
    7
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Downgrading

    Hello, I have started volunteering at an NGO that has really antiquated computers. I would like to make an Access database for them but I am using Access 2010 at home. Can I make a database in Access 2010 and then convert it to be able to run in Access 2003 on Windows XP?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Saleve,

    Welcome to the Lounge as a new poster!

    Yes, this can be done. You have 2 main concerns:

    1. You MUST use the .mdb data file and NOT the .accdb.
    2. You need to avoid any features/controls/etc. that are not available in Access 2003.

    My advice would be that you'd be better off getting a copy of Access 2003 and doing the work there. It's way too easy to use something in 2010 that won't work when ported down. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    saleve (2014-10-18)

  4. #3
    New Lounger
    Join Date
    Oct 2014
    Posts
    7
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Thank you for that fast reply! Another small question... Is there any way to get Access 2003 for my computer? (I'm running Windows 7).

  5. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Saleve,

    Just google "Microsoft Access 2003" lots of choices. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. The Following User Says Thank You to RetiredGeek For This Useful Post:

    saleve (2014-10-18)

  7. #5
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    The only issue I had with an Office 2003 application, FrontPage, was that I had to remove it before installing the 64-bit version of Office 2010, seems the 32-bit versions of Office applications don't work with the newer 64-bit version. Office 2010 is the first to be available as either 32-bit or 64-bit. Both versions are compatible with 64-bit Windows but 64-bit programs won't work on 32-bit Windows.

  8. The Following User Says Thank You to Berton For This Useful Post:

    saleve (2014-10-18)

  9. #6
    New Lounger
    Join Date
    Oct 2014
    Posts
    7
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Thanks!

  10. #7
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    You're welcome.

  11. #8
    New Lounger
    Join Date
    Dec 2009
    Location
    10546
    Posts
    23
    Thanks
    0
    Thanked 3 Times in 2 Posts
    IIRC, there is a free runtie for Access 2010 databases that runs on XP. So if you are doing all the design, I believe that would be an alternative.

    http://www.microsoft.com/en-us/downl....aspx?id=10910

  12. #9
    New Lounger
    Join Date
    Dec 2009
    Location
    Dallas, TX
    Posts
    7
    Thanks
    0
    Thanked 1 Time in 1 Post
    Given the risks with XP, you might also want to be aware that Microsoft has a software donation program (http://www.microsoft.com/about/corpo...are-donations/) for US NGO's. The NGO must apply and be accepted, AND the current version of the OS (Windows 8.1) is the only OS version that's available. Given what you've said about older computers, Windows 8.1 and newer versions of Office 365 may not be an option due to heavier requirements.

    Also a reminder that if the NGO deals with protected health insurance (PHI), a HIPAA security violation can result in ghastly fines and criminal charges where there is willful non-compliance.

  13. The Following User Says Thank You to craigjh For This Useful Post:

    saleve (2014-10-23)

  14. #10
    New Lounger
    Join Date
    Oct 2014
    Posts
    7
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Thank you. That is interesting. It's actually a Swiss charity. As an aside, do most people hate Windows 8 or is it just me? After a year of dealing with the annoying tiles - not to mention the long startup time and inconvenient interface - I changed back to Windows 7.

  15. #11
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    do most people hate Windows 8
    Maybe, but then could be they just don't like change. I've helped some people by the simple free addition of Classic Shell, gets a Start button back and Start Menu on the Desktop view. I guess the phrase of "familiarity breeds contempt" could apply to the visual change of 8/8.1, folks just want the familiar things and have contempt for the new. The 8.1 Update does help somewhat.

  16. The Following User Says Thank You to Berton For This Useful Post:

    saleve (2014-10-23)

  17. #12
    4 Star Lounger
    Join Date
    Jan 2010
    Location
    Fort McMurray, Alberta, Canada
    Posts
    557
    Thanks
    51
    Thanked 68 Times in 66 Posts
    Not sure I agree with the advice to build in Access 2003.

    Here's the problem. You are targetting a 12 year old version of Office and thus your "new" database starts off with a distinctly "old" design goal. Also, Access is strongly versioned and so upgrading tends to be more work than with any other program in the Office suite.

    My general rule of thumb is, Build for the Future, not the Past.

    OK, so it's an NGO. They likely want to keep office overhead and expenses low and upgrading is more of a challenge. However they cannot be unaware of their elderly computing base, and getting support for these old systems is getting difficult. You may be aware that Microsoft has stopped all patching activities for Windows XP for instance.

    Here's the thing. Have you talked to the NGO about the possibility of upgrading? Maybe there's an upgrade in the works you don't know about. Also, your Access database could be the very thing needed to trigger an upgrade.

    Also, you may not need an NGO-wide upgrade. Perhaps your Access database is of limited use within the NGO. In that case the financial committment the NGO makes is lower.

    If you target Office 2010 and Windows 7, this is actually a very conservative design goal in IT terms. In fact this could itself become a bit of a problem--these are no longer the most current Microsoft products. The NGO when it invests in office equipment, likely wants to get the best value and that usually means the newest stuff. You could in fact be facing Windows 8.1 and Office 2013 at the NGO.

  18. The Following User Says Thank You to BHarder For This Useful Post:

    saleve (2014-10-23)

  19. #13
    New Lounger
    Join Date
    Oct 2014
    Posts
    1
    Thanks
    0
    Thanked 1 Time in 1 Post

    Try TechSoup for low cost software for NGO and nonprofit orgs

    Hi! I work in nonprofit technology and if your charity decides to upgrade, I suggest looking into TechSoup.org -- they are a global organization that provides technology and resources to NGOs. Orgs can get substantially discounted software (windows and office, fundraising database, fund accounting, membership management, etc.) through their international programs. They may even be able to get hardware too, depending on the programs available in your country.

    Also, what kind of database does the NGO want you to build? It might actually be less expensive (not to mention less work!) to customize an "off-the-shelf" software/cloud package from TechSoup if they qualify for member discounts. Look into it! They have lots of resources.

    Good luck!

  20. The Following User Says Thank You to tomatosld For This Useful Post:

    saleve (2014-10-23)

  21. #14
    New Lounger
    Join Date
    Oct 2014
    Posts
    7
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Thanks to all of you. The NGO is tiny - there are two of us in the office, i.e., two (very old) computers. They are also quite disorganized and one of my first tasks will be to get things in order. I don't know exactly what the database will look like yet (I just started there), but it will be very specific to their unique work flow. I just upgraded to Access 2013 at home, although I'm still on Windows 7. So I will look into everything... Your input has been really helpful!

  22. #15
    3 Star Lounger
    Join Date
    Dec 2009
    Location
    Courtenay, BC
    Posts
    244
    Thanks
    9
    Thanked 16 Times in 15 Posts
    Just to throw in a couple of suggestions that may or may not be useful.

    1 - if you're going to develop for an older platform, it might be easier to recreate that platform in a virtual PC and work there. Then no version conflicts, etc on your main system. Oracle Virtual Box with an old copy of WinXP you have and stick Office 2003 in there.

    But I agree with the point about building for the future. Fixing the old may be an exercise in futility.

    2 - Another consideration, esp for an NGO, is going with the Open Document standard. Some governments in Europe mandate that. Suites like OpenOffice and LibreOffice fully support that and are free. If you take that route, I'd recommend an external database (Access has the issue too). I review the technique here.
    http://fornow.wordpress.com/2014/10/...ase-databases/

  23. The Following User Says Thank You to DavidFB For This Useful Post:

    saleve (2014-10-24)

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
  •