Results 1 to 3 of 3

Access 2000 mdb to 2007 import failure unrecognized database format

  1. #1
    whisperjet is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2012
    Posts
    2

    Access 2000 mdb to 2007 import failure unrecognized database format

    Hi,



    Long time access 2000 / sql user - trying to import a working access 2000 database into access 2007 - mostly tables queries - after starting the import and selecting the target mdb using browse - i click ok at bottom and dialog box comes up stating the file (shows path and name) is an "unrecognized database format" (then followed by path mdb name).

    any ideas or suggestions truly appreciated

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,566
    Are you able to open the mdb with 2007 then do a SaveAs?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    whisperjet is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2012
    Posts
    2
    I got most of it to import - had to remove code (copy paste into txt file) attached to reports and mark the report property has module as NO - then after import i used the text file to recreate the code for the offending reports.

    Thanks for your response.

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

Similar Threads

  1. Problem running Access 2000 database in Office 2007.
    By pmacafee in forum Programming
    Replies: 1
    Last Post: 07-13-2012, 11:12 AM
  2. Unrecognized database format
    By looloo in forum Access
    Replies: 4
    Last Post: 09-26-2011, 11:33 PM
  3. Database in unrecognized format - 2010 to 2007
    By ajetrumpet in forum Access
    Replies: 2
    Last Post: 03-16-2011, 01:46 PM
  4. Unrecognized database format
    By Frank in forum Access
    Replies: 1
    Last Post: 08-05-2009, 07:35 AM
  5. Unrecognized database format
    By pacala_ba in forum Access
    Replies: 0
    Last Post: 03-19-2009, 10:26 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
  •  
Tech Forums: Microsoft Office Forums