password in dataenvironment connection?
I'm trying to connect a dataenvironment to a acces database protected by password!
I've to fill connection dataenvironment properties: password=mypassword and i keep the admin(the default) as login in the appropriat window!
but the connection coudn't be established. if anyone hase an idea .
thanks
[325 byte] By [
harold] at [2007-11-11 8:49:49]
# 1 Re: password in dataenvironment connection?
There are two types of Access password protection. One is a simple database password and the other is user level security which requires both a user ID and password.
If user level security is implemented the user ID and password would be specified on the Connection tab of the Data Link Properties. If you are just using a database password then that would be specified in the "Jet OLEDB: Database Password" property on the All tab.
If you are trying to specify the database password in the connection string then it would look something like the following:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\...\My Documents\Database\MyDb.mdb;Jet OLEDB:Database Password=Password
# 2 Re: password in dataenvironment connection?
I'm using a simple database password, the connection by the code was established without problem, but I'm lookin to do the same thing by precising the connection properties in the Data Link properties window(the graphic assistant) I kept Admin as user name and mypassord as password. but an error appears!
thanks for help!
harold at 2007-11-11 17:25:58 >
