"jonefer" <jonefer@discussions.microsoft.com> wrote in message
news:1540C0DD-3BFC-4A1C-BA52-02146EC3FEF1@microsoft.com...
> I hope it's really that easy.
> I looked all over for that string, but to no avail.
>
> so, I tried what you suggested and here's the error:
> "Cannot start your application. The workgroup information file is missing
> or opened exclusively by another user"
>
> I followed your template exactly. Here's an additional concern
> should user ID include the domain? or machine name?
>
> for example user id= MyMachineName/someUserID ?
>
> So, it must really be more to it than what you suggested.
>
>
> "Misbah Arefin" wrote:
>
>> <add name="MDB_cn"
>> connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
>> Source=\\MyServer\MyFolder\MyDB.mdb;User
>> Id=someuser;Password=somepassword"
>> providerName="System.Data.Oledb" />
>>
>> here's a good site for connection strings
>> http://www.connectionstrings.com/?carrier=access
>>
>>
>>
>> --
>> Misbah Arefin
>> https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
>> http://dotnethitman.spaces.live.com
>> http://www.linkedin.com/in/misbaharefin
>>
>>
>>
>>
>> "Plateriot" <Plateriot@discussions.microsoft.com> wrote in message
>> news:A452D5B4-5C22-4D2D-863D-59C940F7608A@microsoft.com...
>> > I have a website in which I connect to a SQL SERVER via SQL username
>> > and
>> > password
>> >
>> > I added another connection string in hopes of connecting to a Networked
>> > MDB
>> > to get updates to the SQL Server.
>> >
>> > This 2nd connection string has a generic username and password,
>> > provided
>> > to
>> > me by the System administrator.
>> >
>> > Where in my 2nd connection string do I add the generic username and
>> > password
>> > provided by the System administrator?
>> >
>> > Here's the connection string piece of my Web.Config:
>> >
>> >
>> > <connectionStrings>
>> > <add name="SQL_cn" connectionString="Data Source=MYSERVER;Initial
>> > Catalog=MYDb;Persist Security Info=True;User
>> > ID=myusername;Password=mypassword"
>> > providerName="System.Data.SqlClient"/>
>> > <add name="MDB_cn"
>> > connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
>> > Source=\\MyServer\MyFolder\MyDB.mdb" providerName="System.Data.Oledb"/>
>> > </connectionStrings>
>>