Connection to DataBase

[[Gho]]

Hi,
I make a local database by using Access XP.
I connect to this file by the following string:

this.conStr = "Provider=Microsoft.JET.OLEDB.4.0 ;data
source= MyDa.mdb";

What I have to do to be able to have a Password to this
file, and how to open it ?

[Andrew Gnenny]

Hi,
Your connection string will be like this:
"Provider=Microsoft.JET.OLEDB.4.0 ;data source= MyDa.mdb;User
ID=someuser;Password=somepassword;"
--
Andrew Gnenny
pulsar2003@/no-spam/email.ru (Please remove /no-spam/ for reply)
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE
"[Gho]" <yo*****@taux01.nsc.com> wrote in message
news:02****************************@phx.gbl...

Hi,
I make a local database by using Access XP.
I connect to this file by the following string:

this.conStr = "Provider=Microsoft.JET.OLEDB.4.0 ;data
source= MyDa.mdb";

What I have to do to be able to have a Password to this
file, and how to open it ?

[[Gho]]

I get the following Error:
"Cannot start your application. The workgroup information
file is missing or opened exclusively by another.."
Why?
the database is closed befor running the application

-----Original Message-----
Hi,
Your connection string will be like this:
"Provider=Microsoft.JET.OLEDB.4.0 ;data source= MyDa.mdb;UserID=someuser;Password=somepassword;"
--
Andrew Gnenny
pulsar2003@/no-spam/email.ru (Please remove /no-spam/ for reply)X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE
"[Gho]" <yo*****@taux01.nsc.com> wrote in message
news:02****************************@phx.gbl...

Hi,
I make a local database by using Access XP.
I connect to this file by the following string:

this.conStr = "Provider=Microsoft.JET.OLEDB.4.0 ;data
source= MyDa.mdb";

What I have to do to be able to have a Password to this
file, and how to open it ?

.

[Andrew Gnenny]

Hi,
This error occurs when the application cannot find the System.mdw file. On
Win2000 this file resides at
Program Files\Common Files\System\
This may help:
1. Copy your System.mdw file into the application database folder

- OR -

2. Specify "Jet OLEDB:System Database" parameter in your connection string
Jet OLEDB:System Database=C:\Program Files\Common Files\System\SYSTEM.MDW

3. Optional. Specify the password for the system database
Jet OLEDB:Database Password=12345

--
Andrew Gnenny
pulsar2003@/no-spam/email.ru (Please remove /no-spam/ for reply)
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE
"[Gho]" <yo*****@taux01.nsc.com> wrote in message
news:06****************************@phx.gbl...

I get the following Error:
"Cannot start your application. The workgroup information
file is missing or opened exclusively by another.."
Why?
the database is closed befor running the application

-----Original Message-----
Hi,
Your connection string will be like this:
"Provider=Microsoft.JET.OLEDB.4.0 ;data source=

MyDa.mdb;User

ID=someuser;Password=somepassword;"
--
Andrew Gnenny
pulsar2003@/no-spam/email.ru (Please remove /no-spam/ for

reply)

X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE
"[Gho]" <yo*****@taux01.nsc.com> wrote in message
news:02****************************@phx.gbl...

Hi,
I make a local database by using Access XP.
I connect to this file by the following string:

this.conStr = "Provider=Microsoft.JET.OLEDB.4.0 ;data
source= MyDa.mdb";

What I have to do to be able to have a Password to this
file, and how to open it ?

.

[[Gho]]

i copied the System10.mdw to my current directory.
Whats wrong with the following?

this.conStr = "Provider=Microsoft.JET.OLEDB.4.0;Jet
OLEDB:System Database= C:\\System10.mdw; data source =
C:\\SuperIO_Chips.mdb;UserID=MySeflf;Password=MyPa ss;Workst
ation ID=VL51het83rOIQQo";
thanks

-----Original Message-----
Hi,
This error occurs when the application cannot find the System.mdw file. OnWin2000 this file resides at
Program Files\Common Files\System\
This may help:
1. Copy your System.mdw file into the application database folder
- OR -

2. Specify "Jet OLEDB:System Database" parameter in your connection stringJet OLEDB:System Database=C:\Program Files\Common Files\System\SYSTEM.MDW
3. Optional. Specify the password for the system database
Jet OLEDB:Database Password=12345

--
Andrew Gnenny
pulsar2003@/no-spam/email.ru (Please remove /no-spam/ for reply)X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE
"[Gho]" <yo*****@taux01.nsc.com> wrote in message
news:06****************************@phx.gbl...

I get the following Error:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another.."
Why?
the database is closed befor running the application

>-----Original Message-----
>Hi,
>Your connection string will be like this:
>"Provider=Microsoft.JET.OLEDB.4.0 ;data source=

MyDa.mdb;User

>ID=someuser;Password=somepassword;"
>--
>Andrew Gnenny
>pulsar2003@/no-spam/email.ru (Please remove /no-spam/ for

reply)

>X-Unity Test Studio
>http://x-unity.miik.com.ua/teststudio.aspx
>Bring the power of unit testing to VS .NET IDE
>
>
>"[Gho]" <yo*****@taux01.nsc.com> wrote in message
>news:02****************************@phx.gbl...
>> Hi,
>> I make a local database by using Access XP.
>> I connect to this file by the following string:
>>
>> this.conStr = "Provider=Microsoft.JET.OLEDB.4.0 ;data
>> source= MyDa.mdb";
>>
>> What I have to do to be able to have a Password to

this >> file, and how to open it ?
>
>
>.
>

.