Solved

Set MDB password and use it

Posted on 2000-04-06
7
195 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 

Accepted Solution

by:
kojot earned 200 total points
ID: 2692402
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
ID: 2692632
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
ID: 2693295
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 70

Expert Comment

by:Éric Moreau
ID: 2694437
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
ID: 2698850
Thank you very much.
0
 

Author Comment

by:hxb
ID: 2698853
Thanks kojot and emoreau.
0
 

Expert Comment

by:kojot
ID: 2699632
No problem! Mail if you need any more help.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

726 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