Connection to DataBase

  • Thread starter Thread starter [Gho]
  • Start date Start date
G

[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 ?
 
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
 
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
 
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
 
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=MyPass;Workst
ation ID=VL51het83rOIQQo";


thanks
 
Back
Top