> Hi, a question
>
> I use a mdb database for my application. The application should be able
> to handle more than one mdb, so I think I have to change
> my.settings.ConString  (this is my connectionstring) Like this
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\DAT.mdb;Persist Security
> Info=True;Password=password;User ID=user;Jet OLEDB:System
> database=c:\security.mdw;Jet OLEDB:Database Password=password
>
> The only thing I want to change is the data source element...
>
> But this setting is read only and the scope cannot be set to "User"
>
> Or am I on the wrong way?
>
> Greetings from Germany
> Andre

> Hi Andre,
>
> you need to setup a string variable and concatenate it in the
> connection string.
> Here is an example from a connection of mine:
>
>                 Me.ConnectionString = _
>                       "Provider=Microsoft.Jet.OLEDB.4.0" & _
>                       ";Data Source=" &
> Me.InformazioniFileDatabase.NomeFile & _
>                       ";User ID=" & UserId & _
>                       ";Jet OLEDB:Database Password=" & Password & _
>                       ";Mode=Share Deny None"
>
> the database property is just for information, once you have connected.
>
> -tom
>
> Andre Rode ha scritto:
>
>> Hi, a question
>>
>> I use a mdb database for my application. The application should be able
>> to handle more than one mdb, so I think I have to change
>> my.settings.ConString  (this is my connectionstring) Like this
>> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\DAT.mdb;Persist Security
>> Info=True;Password=password;User ID=user;Jet OLEDB:System
>> database=c:\security.mdw;Jet OLEDB:Database Password=password
>>
>> The only thing I want to change is the data source element...
>>
>> But this setting is read only and the scope cannot be set to "User"
>>
>> Or am I on the wrong way?
>>
>> Greetings from Germany
>> Andre
>

"Andre Rode" <Angel-***@gmx.de> schreef in bericht
news:e74ava$urf$1@online.de...
> Hi, a question
>
> I use a mdb database for my application. The application should be able to
> handle more than one mdb, so I think I have to change
> my.settings.ConString  (this is my connectionstring) Like this
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\DAT.mdb;Persist Security
> Info=True;Password=password;User ID=user;Jet OLEDB:System
> database=c:\security.mdw;Jet OLEDB:Database Password=password
>
> The only thing I want to change is the data source element...
>
> But this setting is read only and the scope cannot be set to "User"
>
> Or am I on the wrong way?
>
> Greetings from Germany
> Andre