Results 1 to 4 of 4
  1. #1
    NISMOJim is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2010
    Posts
    273

    Open older version of database


    My office just converted to Access 2013 this week. Most of my databases created in Access 2007 seem to be doing ok except for opening very slowly, but I have one that uses Access 2003 on a card reader system. I copy this database nightly, and paste it on my computer. From there, my new database runs a macro to append transactions from the old database, and add them to an existing table in the new one. Once the data is in the new database, I can run my reports. Now when I try to run the macro, I get an error message that says Access can't open a database created in a previous version. Even trying to open the old database directly, I get the same message. If I can't open the database to convert it to 2013, what can I do?
    Thank you for your help.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    You can link to mdb files using 2013. You can open mdb files using 2010 or earlier. However, macro objects may or may not function correctly.

  3. #3
    NISMOJim is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2010
    Posts
    273
    I will try linking the tables later today to see how that works. However, since the transactions in the old db are archived each month, wouldn't I lose access to the previous months data in the new db?

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The idea of linking vs. converting the mdb is that linking will preserve the db you link to.

    For instance, I have a couple mdb files that act as backends where users that have everything from Access 2003 to 2013. What I would not allow to happen is for a user to open that mdb file directly from their machine. When I do maintenance on mdb files I will do it via linking. If I need to do so something to the mdb file that cannot be accomplished via linking, I will boot up and old XP box and open the file with Access 2003.

    Having said that, I do not think I would try to create a new table in an mdb file with Access 2013. But, that may just be me and my crazy way of thinking.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Command Buttons on older version of Access
    By Ceadmo in forum Access
    Replies: 7
    Last Post: 05-03-2015, 01:47 PM
  2. Replies: 2
    Last Post: 04-17-2013, 08:53 PM
  3. Replies: 2
    Last Post: 03-14-2013, 04:43 AM
  4. Older version Access upgrade to Win-7 64
    By SteveACCESS in forum Access
    Replies: 1
    Last Post: 04-02-2012, 05:46 PM
  5. Replies: 5
    Last Post: 10-28-2011, 12:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums