Discussion Locked

how can I set or remove password from DB

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want my Visual Basic program to remove the Access Db password when my program starting and set the password again when I close my program
and I want the database still shared not just for exlusive
so I need someone to help me how can do that
thanks for helping

6 replies

by john_wills

I must have misunderstood. Or do you really want people to be able to log on without a password so long as someone else is already logged on?

by khalid

No Just I don't want anyone to open my DB from the access without my program
ihope you understand what I mean

by whyong

set the pwd for your db.
in the visual basic program, provided the password when you create the connection.
example if you are using ado,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Persist Security Info=True;Jet OLEDB:Database Password="... fill in the datasource and Pwd..

This discussion is closed to new replies.