Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Unanswered: Access 2007 Assets Database.accdb saved as Access 2003 .mdb?

    I just got Office 2007 on XP installed at home. I looked at the new templates in Access and found that the Assets Database is just what I need on my job (inventory/asset management for office automation products). At work we are still running with Office 2003/XP. We are not jumping up to Office 2007 for the foreseeable future. Question: Is it possible to get the Assets Database from Access 2007 to run in Access 2003-compatible mode?
    http://office.microsoft.com/en-us/te...CT101428241033

    Thanks to anyone who can answer this one.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    in access 2003

    you can

    Tools-> database utilities -> convert database -> To ..........

    doe 2007 have the same function ??
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Nov 2007
    Posts
    2
    Nope.

    Here is the answer I posted over at mrexcel.com:
    Okay, I guess I'll answer my own question.
    Nope, won't work. Copied and pasted the Assets database.accdb template from my Office 2007 desktop to my Office 2003/XP laptop (okay, not mine, belongs to my employers). Attempted to save it as an earlier version of Access without success. Even attempted to rename the file extension from ".accdb" to ".mdb". Uh-uh, no-go.

    Any better ideas?

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No, you'd have to convert in down using 2007. Then you should be able to use it with 2003:

    Microsoft Office Button | Save As | Access 2002 - 2003 Database
    Paul

  5. #5
    Join Date
    Jun 2008
    Posts
    4
    To get from an .accdb to an .mdb, you say "No, you'd have to convert in [sic] down using 2007."

    How do you even do this? I can't figure out how (using MS Access 2007)...

    Also, I saw a post on a Hong-Kong-based forum that told how to switch the DEFAULT file type in MS Access 2007 to an older version (e.g., 2000 or 2003), but the menu options they mentioned don't exist. Any ideas on how to do this??

    Thanks!

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Quote Originally Posted by pbaldy
    Microsoft Office Button | Save As | Access 2002 - 2003 Database
    To set the default

    Microsoft Office Button | Access Options | Popular
    Paul

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    And that will only affect databases created from that point on.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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