dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: password in dataenvironment connection?

  1. #1
    Join Date
    Feb 2005
    Posts
    19

    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

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    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:

    Code:
    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\...\My Documents\Database\MyDb.mdb;Jet OLEDB:Database Password=Password
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Feb 2005
    Posts
    19
    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!

Similar Threads

  1. Replies: 1
    Last Post: 01-07-2006, 01:19 PM
  2. Using Passwords for Log-in's
    By Tricia in forum VB Classic
    Replies: 6
    Last Post: 03-30-2002, 02:23 PM
  3. Can I hide password information in an ADO Connection object?
    By Filipo Novo Mór in forum VB Classic
    Replies: 10
    Last Post: 01-31-2001, 12:17 PM
  4. Replies: 1
    Last Post: 10-24-2000, 04:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center