Solved

Set MDB password and use it

Posted on 2000-04-06
7
185 Views
Last Modified: 2010-05-02
I set the MDB password in Office97 Access:
Menu Tools-> Security->set database password-> and then input password OK.

In vb6, Menu->Project-->More ActiveX
Designer ->Data Enviroment
and then:
   Dataenviroment1
     connection1
I set the property of connection1,
the provider is Microsoft Jet 4.0
OLE DB Provider.
And next is input the database name,
and user name password.
After I input the user name and password,
I click the buttom of TEST CONNECTION,
it run error.  
why ?

Please give me detail answer.

Thanks  
0
Comment
Question by:hxb
  • 4
  • 2
7 Comments
 

Accepted Solution

by:
kojot earned 200 total points
Comment Utility
Open the database in RUNTIME ONLY! However, if you want to open it for administration or design time you must use ODBC resources provided by Windows. Visual Basic can connect to the password protected database only if ODBC is properly configured.

Hope that helped!

Igor.
0
 

Author Comment

by:hxb
Comment Utility
Thank for your help.
I have tried it, build a ODBC and
it is OK.

That means in administration or design time, I must use ODBC resources.
And then in running time,
I should change the provider string
and use Microsoft Jet 4.0
OLE DB Provider.

Is it?
0
 

Author Comment

by:hxb
Comment Utility
I have some problem in running time,
because I do not know how to
set the provider and password
that using Microsoft Jet 4.0 OLE DB
Provider.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 69

Expert Comment

by:Éric Moreau
Comment Utility
In the Connection tab, don't set User Name and password (leave them as they are).

After setting the database name, goto the ALL tab, select "Jet OLEDB: Database password", click on "edit Value" and enter your password.
0
 

Author Comment

by:hxb
Comment Utility
Thank you very much.
0
 

Author Comment

by:hxb
Comment Utility
Thanks kojot and emoreau.
0
 

Expert Comment

by:kojot
Comment Utility
No problem! Mail if you need any more help.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now