Solved

Set MDB password and use it

Posted on 2000-04-06
7
191 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
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

790 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