VB3 & MS Access 2.0 ...SECURITY
on 1 Sep 1996 21:00:50 GMT,
Quote:
>I'm using VB 3 and MS Access v2.0
>Goal:
>I've want to protect my access database (MyDB.MDB) from being
>read (viewed or anything else) by anyone except MY Application.
>I've been reading about the SYSTEM.MDA, but from what I can see,
>if this file is simply replaced by a 'clean' system.mda....
>......anyone can gain access to the database. Some security.
>Is there a way to protect my database ?
>-- Mike
Yes, there is a way (I wonder why ALL of us has made this question someday..)
Just follow this script:
- Create a new user and give it all privileges to DB, Tables, Queries...
- Give a Password to user 'Admin'. That will force Access to prompt you for
your ID and password next time you launch it.
- Re-enter Access. Give the ID and password of the new user you created
- Once you have done this you are at Access environment logged as a new user.
This last step was neccesary since if you create your DB logged as 'Admin',
everyone will be able to OPEN it.
- Now, create your new DB. Once you have done it, CLEAR all privileges for
the DB, Tables, ... to ALL USERS AND GROUPS except YOUR new user.
- Now, my friend, you have a totally secured DB. If you distribute the MDA
you will be able to access to it using SetDefaultWorkSpace (Yeah, I know
you already know that). But if they substitute your MDA with a new one,
they won't be able to do it because they are trying to log as 'Admin' or
'Guest' and they have NO privileges at all...
I'm sure this helps (er... I hope so :-) )
Fernando
------ 'Nothing important has been done without passion' -----------
