Need help on Access Security ASAP

[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

 

[philhege]

Um, probably best asked in the Access forum. Or the ASP forum.

That said, your best solution probably involves SSL.

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....
-----------
A skeleton walks into a bar, and says "I'll have a beer and a mop.