Access Security ASAP 1

[krizsy]

We have Access 2003 database that includes sensitive information. We use ASP as the frontend.

The database should be accessible by only one domain admin and needs to be secure from all other
access by everyone else.

- Setting permissions on the DB to just the domain admin won't work because other domain admins could apply
permissions and then open it

- We could set a password on the database but then how do we pass the password to the DB from the ASP front
end without sending the password in clear text? = THIS IS THE KEY QUESTION

- We can't upsize to SQL because then other SQL admins could set permissions and then view the database

 

[LNBruno]

Have you tried going into the table properties and setting them to hidden?

< M!ke >

 

[LNBruno]

A word of warning: make sure you've got a backup before you do that or YOU won't be able to get into them either!!!

< M!ke >

 

[krizsy]

Thank you, once it is hidden how do I unhide it and can someone else unhide it? Only one person can have access to it and how about the asp as far as passing the password any ideas?

 

[LNBruno]

Once it's hidden, you CAN'T unhide it -- you can't even open a blank Access database and import it even; that's the reason for making a backup copy (development version, so to speak).

As for the ASP, I'm afraid I can't help you there. Maybe you could post that specific question in the ASP forum.

Best of luck!



< M!ke >

 

[krizsy]

Thanks that is what I thought, my boss is trying to do this quickly and I am doing my best to get the answer he wants but it seems he always adds a twist to it.

 

[LNBruno]

Well, of course!

My mentor was fond of saying, "Well, if you wanted it yesterday, you should have asked me for it tomorrow!"

< M!ke >

 

[krizsy]

Yeah I know what you mean. Hopefully I can figure something out to satisfy him. Thanks for your help.