VS2010(C#) and MS Acces 2007

Posted on 2011-04-28
Last Modified: 2013-12-16
How to create New Connection to MS Access database 2007 in VS 2010?

I went to Server Explorer--->Data connections-->rigth click---> Add connection--->selected Microsoft ODBC Data Source---> selected my DSN (i created it before in control panel-->admin tools)---> Entered UserName and Password(the same I use in DSN)---> clicked Test connection--> my VS crashed

Can you please provide an example how to connect to Access 2007 from Vs2010?
Question by:niceguy971
    LVL 17

    Accepted Solution

    Hi, step by step:
     Step 1 Step 2 Step 3 Step 4That's it!

    Author Closing Comment


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 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

    18 Experts available now in Live!

    Get 1:1 Help Now