Results 1 to 4 of 4
  1. #1
    arnewank is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2015
    Posts
    1

    *.MDF' cannot be opened

    I'm trying too attach a database but am getting the following error:

    cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported.( using ms sql server 2005 and vs2008 )

    so my question is
    How to copy out the data from that database ? , i don't want upgrade or downgrade versions.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Should MDF be MDB?

    You want to link VisualStudio to an Access db residing on server?

    Can you open the db if it is on local computer?
    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
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    MDF File Type: SQL Server Database File
    Primary database file format used by Microsoft SQL Server, an enterprise-level database program; used for database files installed with SQL Server and related add-ons

    How to copy out the data from that database ?
    Options:
    1) Find another computer that you can load a later (newer) version of SQL Server Express (SQL Server 2008) on and export the data. (Excel, CSV files,??)
    From what I have read, there is NO downgrade path.
    2) Convert (aka upgrade) SQL server to the correct version to open the MDF file.



    Internal SQL Server Database Version Numbers
    http://weblogs.sqlteam.com/dang/arch...n-numbers.aspx

    Microsoft SQL Server Internal Database Versions
    http://sqlserverbuilds.blogspot.ru/2...-versions.html

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Depending on what it is you are trying to accomplish, maybe you can download SSMS to another machine and use that machine to script out the various schemas needed.

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

Similar Threads

  1. Replies: 5
    Last Post: 03-27-2017, 07:48 PM
  2. Replies: 2
    Last Post: 08-13-2014, 06:55 PM
  3. read only database when opened with an app
    By jpimlott in forum Access
    Replies: 3
    Last Post: 01-05-2012, 07:10 PM
  4. Replies: 17
    Last Post: 05-23-2011, 07:27 AM
  5. Can not close pop up form after second pop was opened
    By snoopy2003 in forum Programming
    Replies: 2
    Last Post: 03-09-2011, 02:56 AM

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