ms access security

[TheRiddler]

Anyone knows how you can secure an ms access database so it can be safely used as database for a large asp site? Or how to use asp data encryption into the database.

[rdoekes]

if you say large ASP site, and large in the sense of number of hits and reads/writes to the database, my first inclination is to say, think about another database solution.

But if you are set on msAccess, ensure that the database is outside of directories where your site is located, and you also might wanna put a strong password on the database.

As for data encryption, i believe you have to do that in ASP when you are working with a MS access database, but i could be mistaken

[PeOfEo]

also ms access if the server does not have some security inplace for that format .mdb a user can just download your batabase. So if you try to use a logical name and the person who is after your data is a good guesser your sol. I would suggesting using msde or mssql server if you have to either of them.