Lock Access DB ?

[vbNeo]

Can i lock an access database making it capable of being opened by my ASP application only? For security reasons?(A lot of personal info is going to be stored in it ...)

Cheers!

[Danial]

You could password protect the mdb file and the supply the password from your asp application.

ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(".") & "\data\rob.mdb; User Id=danial; Password=test;"

But i should inform you that the password protection system in access is a joke. You could crack it with few lines of vb code !!.

The best way is to encrypt the personal data and then store the encrypted data on the access db. You could get pretty strong encryition algorithm, available as component or pure asp code. I might have AES algorithm implement in asp some where in the hard disk.

Just do a seach on google you should be able to find other encryption algorithm that would be more then sufficient for you.

Hope this helps.

Danial