• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Set MDB password and use it

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
hxb
Asked:
hxb
  • 4
  • 2
1 Solution
 
kojotCommented:
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
 
hxbAuthor Commented:
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
 
hxbAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Éric MoreauSenior .Net ConsultantCommented:
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
 
hxbAuthor Commented:
Thank you very much.
0
 
hxbAuthor Commented:
Thanks kojot and emoreau.
0
 
kojotCommented:
No problem! Mail if you need any more help.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now