Connect  a mdb file.

Posted on 2011-10-31
Last Modified: 2012-05-12
Hello, I used SQL Server one years ago. Now I almaost forget everything. I have a file C:\BAND\player.mdb. How can I connect it by SQL Server 2008 R2?
Suppose SQL Server Authentication is used.

Question by:zhshqzyc
    LVL 69

    Expert Comment

    by:Éric Moreau
    a mdb file is an Access file not a SQL Server

    but you can use OpenRowset as shown in

    SELECT *
       FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    Author Comment

    I meant to connect it from SQL Server Management Studio.
    LVL 69

    Accepted Solution

    you can't, it is an Access database

    the only way would be to upgrade it from Access to SQL

    Author Comment

    Okay. If it is a mdf file, can I do it?
    LVL 50

    Expert Comment

    if its from sql 2005 yes , sql 2000 probably

    sql 7 or earlier probably not...

    do you know which version created it?

    go into management studio right click databases and try attach database...
    LVL 3

    Expert Comment

    Yes, then you can attach to it..


    Author Comment

    I followed a book by APRESS, the author use an example by SQL Server 2005 connect a mdb file on management Studio.
    However SQL Server 2005 is a legacy technology. You know, the popular is 2008.
    Then the question was arised.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now