How do I Change web.config Connection Sting to Use Access Database

Posted on 2014-08-31
Last Modified: 2014-09-15
How do I convert Web.config SQL Server Connection String to MS Access
This is on my local machine using IIS 8.5

This is my old SQL Server code the access file is named PLF but there is no user or password
 <add key="ConnectionString" value="server=DONSR\sqlserverexpress,1433;Trusted_Connection=False;database=PLF;UID=sa;PWD=cool4309" />

Question by:dplsr
    1 Comment
    LVL 62

    Accepted Solution

    Hi  dplsr;

    Here is a link to a web page that will show how to form a connection string depending on options need such as data providers security and others.

    Access connection strings

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    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.

    761 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

    9 Experts available now in Live!

    Get 1:1 Help Now