Very Computer

Could anybody give me step by step instructions how to protect Access
database with Password and then to open it in Data Environment. I'm doing
something wrong and can't understand what. All the time when I'm testing
connection I get an error message about invalid password or user name. I
tryed to secure db with Password, I tryed to create User with Password.
Everything fails.
Thank you.
Vlad

Martin,

OpenDatabase is a DAO method.  Vlad is using the Data Environment in VB, as
in ADO.

--
Later,
Tony Fountain, MCP
--------------------------------
Please do not email me directly, my wife already clutters up my inbox
tonyfo at primenet dot com
ICQ# 16575458

Please look up in the help at opendatabase method. This must help you. I use
it in Vb al the time

Kind regards Martin.

Vlad Chapranov heeft geschreven in bericht ...

Thanks for answer. Please anybody repete my following steps and tell me
where is my mistake?
I do the following steps:
1. I make a copy of NWind.mdb from VB folder to my Test folder.
2. I open exclusivly NWind.mdb
3. Through Tools-Security-Set Database Password I enter the word
 'Test' twice (without quotes).
4. I close NWind
5. I open NWind, it gives me "Password Required" dialog.
6. I enter 'Test'. DB opens. Fine.
7. I start new VB project and add trough Project-More ActiveX Disigners-
 DataEnvironment DataEnvironment1
8. There is Connection1 inside
9. I make right click on Connection1 and click on Properties
10.Data Link Properties dialog appears.
11.Either double clicking on Microsoft Jet OLEDB3.51 Provider or
 highlighting the same item and clicking on Next button brings
 me to the tab where I select NWind.mdb (my copy).
12.By default User Name is Admin, I enter 'Test' (my password). I tried
 to enter password on the Connection tab and on the All tab with
 the same bad result.
13.I click on Test Connection button and receive Error message saying:
 "Test connection failed because of an error in initializing
 provider.Can't start your application. The workgroup information
 file is missing or opened exclusively by another user"
I tried to protect DB different way (steps from 1 to 6). I set a password
through Tools-Security-User and Group Accounts (in Access ofcource), I was
able to open NWind as Admin with 'Test' password in Access, but I had the
same error message in VB with Data Environment.
Assuming that something is wrong with installation of Access or VB I
repeted my steps on several computers with no success. Sorry for so long
description, I just want to be more informative to avoid some
misunderstanding.
What I'm doing wrong or missing?

Thank you
Vlad

Thanks, God.
I've got it solved. On advanced tab I assigned my password to OLEDB Password
and cleared Password property