Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to define connection string for ms access files.
Ask Question

How to define connection string for MS Access files.

Manoj Bhatt 1659 12 Jan 2016
Good day everybody

I am using Microsoft Visual Studio 2012 &  Windows 8.1. I have imported access file to Visual Studio by add Connection.
I want to make a connection to that file and display one of the table in a Web Form.
What should I write in the connection string.
CAN ANYBODY HELP ME AS SOON AS POSSIBLE .
c# c#.netdatabase connection
Updated 12 Jan 2016
Manoj Bhatt
Manoj Bhatt

Other

Message

1 Answers

Anupam Mishra
Anupam Mishra 12 Jan 2016
Report Abuse
The best place to store the database is in the App_Data folder. In you placed it there, you can use the DataDrectory Directive, otherwise you need to use the full path. Also, instead of using the "database" keyword in the connection string, it should be "data source" Provider=Microsoft.ACE.OleDb.12.0;Data Source=|DataDirectory|db1.mdb
Also, when using an mdb file, you might as well use the OleDb 4.0 provider, which is installed on all Windows Servers Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|db1.mdb. Here 'db1.mdb' is your access file.

MindStick Training