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

ACCESSING PASSWORD PROTECTED DATABASES

Iam using MS Access 2000 as my backend, i have given database password.
But when i try to open using ADO Connection open , i am not able to
do so iam getting the following error:

Cannot start your application, the workgroup information file is
missing or opened exclusively by another user.

I have set only database password, no user accounts!!!
How to correct this ...Can any one give me the detailed coding ?
0
parthicaps
Asked:
parthicaps
1 Solution
 
sudhi022299Commented:
Are you sure that your application is the only one that is accessing that file. If you have opened that file in Access, then close it and then run your program.

Regards,
Sudhi.
0
 
SiM99Commented:
I'm pretty sure that you can only use Access 97 databases with VB :|
0
 
KamiroCommented:
Can you post your code where you are building the connection?

Have you set the specific Jet OLEDB Property called JetOLEDB:System Database?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
MTroutwineCommented:
Hi,

If you are setting the password through Tools->Security->Database Password, then try this:

With myConnectionObject
     .Provider = "Microsoft.Jet.OLEDB.4.0"
     .Properties(15).Value = "mydatabasepassword"
     .open "C:\mydatabase.mdb"
end with

Property #15 is Jet OLEDB:Database Password and allows you to call the database password!






0
 
parthicapsAuthor Commented:
Its working fine, is this possible to
write this coding in the following syntax :
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.path + "\databasename;Persist Security Info=False" ....
0
 
MTroutwineCommented:
Yes you can include it in the connection string as follows:
With cnnConnection
        .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\mydatabase.mdb; Jet OLEDB:Database Password=mydatabasepassword"
        .Open
    End With

:>)
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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