How protecting a mdb database ?

[PaulLag]

Hi everybody,

I am new to the forum, and I'd need some piece of advice.

I've looked in the previous post but I did not found what I am looking for.

The issue is: how can I protect a mdb database from password recovery devices ?

In shorts: I have to send this mdb file to somebody, but I don't want him to open this mdb but only to send it some queries.
At the moment, he can open this mdb file with a password recovery device.

Thanks in advance

PLag

 

[speakers_86]

Adding a password to the db is a weak kind of security. You should look into user level security. Beware, if you send him your db, it is possible to start a new blank db, and use the import feature to import your db. Voila, your db with no security!

My opinion is if you dont trust him for some reason, dont send any sensitive info to him. If he is experienced and you are not, hell find a hole in your security.

 

[PaulLag]

Many Thanks !

Are there any alternative solutions instead than using a mdb database ?
The final aim is that this mdb files is accessed by a software that picks up some tabled data.
therefore the question is: what shall I use instead than mdb with this software to work in complete security ?

Many Thanks

 

[neileg]

I think that if security is that important then you shouldn't be using Access. The best you are going to do is make it an mde first and then use Access security. The password can still be recovered but the design is locked down.

 

[Singh400]

Adding a password to the db is a weak kind of security.

I read this alot. Any reason why? Links to articles on this subject would be awesome.