Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


VS2010(C#) and MS Acces 2007

Posted on 2011-04-28
Medium Priority
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

Carlos Villegas earned 2000 total points
ID: 35488658
Hi, step by step:
 Step 1 Step 2 Step 3 Step 4That's it!

Author Closing Comment

ID: 35493868

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

571 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