Access Security

[Damian75]

Hello,

I'm trying to create an access database for document control. My issue is
that I want the database to be publically accessible. In other words, I want
others to log onto the database through prompt screen when they open the
database shortcut. However, I don't want anyone to go into the data via
Microsoft Access and open it from it's saved location. My fear is that they
will be able to go through this backdoor and acces sensitive material. How
can I lock this out? How can I trace to see if anyone has in fact gone
through this backdoor?

 

[Alex White MCDBA MCSE]

Set a database password on the backend database and whatever front-end you
are using connect to the back-end with the password.

 

[Joan Wild]

Hello,

I'm trying to create an access database for document control. My issue is
that I want the database to be publically accessible. In other words, I
want
others to log onto the database through prompt screen when they open the
database shortcut. However, I don't want anyone to go into the data via
Microsoft Access and open it from it's saved location. My fear is that
they
will be able to go through this backdoor and acces sensitive material.
How
can I lock this out? How can I trace to see if anyone has in fact gone
through this backdoor?

I don't follow what the backdoor is. If you've secured it properly, then
they'll have to login to open the mdb. It sounds like you're saying anyone
can open Access and open your mdb. If that's the case, then you missed a
step in securing it.

 

[Damian75]

Thanks for that Joan. Is there anyway to trace to see if anyone has opened
up Access and gone into the mdb that way?

 

[Joan Wild]

Thanks for that Joan. Is there anyway to trace to see if anyone has
opened
up Access and gone into the mdb that way?

If you secure it properly, there would be no need to trace this. One way to
test if you've implemented security properly is to try and open it in
Windows explorer while joined to the standard system.mdw workgroup file.
You shouldn't be able to even open the mdb.

 

[TC]

I say he is asking this: "I've written some programs (code.mdb) to
access my database (data.mdb). How do I stop someone opening data.mdb
directly, instead of using the programs in code.mdb?" The "back door"
that he referrs to, is opening data.mdb directly, without using
code.mdb.

OP: is that what you are asking?

TC