Results 1 to 3 of 3
  1. #1
    tndinnc is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    11

    ACCDB - can't open in 2007 or import


    I just finished a week long database project. All ready to show the users - who have 2007. I have 2010. I can't get it to open on their PCs even though it's saved as 2007 set. So I try to import it into 2007 - nope no going. Can I install 2010 runtime on their PC and have that database automatically open with it - or is there another work around for this ................. I thought I was done

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Have you tried opening the dB in design view in A2010, then doing a "Save As" and saving in (converting to a previous version) A2007 format? (that is all I got )

  3. #3
    tndinnc is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    11
    Quote Originally Posted by ssanfu View Post
    Have you tried opening the dB in design view in A2010, then doing a "Save As" and saving in (converting to a previous version) A2007 format? (that is all I got )
    Thanks, what I actually ended up finding was some VBA code that will export all my queries and tables into a .MDB. Then manually did my module and macros. Everything went well till I moved the forms - then I couldn't open the new MDB. So I ended up installing Office 2010 runtime as a part of packaging the database. I was concerned about that because of the security warnings issue but I just manually created the correct keys and ODBC connection before opening so it works.

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

Similar Threads

  1. Access 2007 import fix width ANSI text file
    By jsama in forum Import/Export Data
    Replies: 0
    Last Post: 03-05-2013, 09:07 PM
  2. Accdb To Accde Transfer, Access 2007
    By Luu in forum Access
    Replies: 3
    Last Post: 01-19-2013, 12:30 AM
  3. Access 2003: import csv fails as csv is still open
    By vanthien in forum Import/Export Data
    Replies: 3
    Last Post: 01-06-2013, 07:46 PM
  4. MS 2007 files won't open from VBA in Access 2007
    By gopherking in forum Programming
    Replies: 1
    Last Post: 02-24-2012, 02:44 PM
  5. Can't create 2007 format accdb!
    By tym in forum Programming
    Replies: 1
    Last Post: 12-08-2011, 02:47 AM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums