1

How can I set a password for an Access Database file, so that no user can recover this password.

fixer1234
  • 27,064
  • 61
  • 75
  • 116
Hossein Moradinia
  • 315
  • 6
  • 18

1 Answers1

3

There are utilities to break this security: http://www.snapfiles.com/get/dbpwsniffer.html

So I wouldn't trust an access password to protect your data.

We store the data in SQL server and use SQL Native encryption which relies on NTFS authentication to decrypt.

Sam
  • 477
  • 3
  • 12
  • Please More Details About Sql Native Encryption ... – Hossein Moradinia Feb 09 '10 at 06:57
  • http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm – Sam Feb 23 '10 at 16:05
  • The cited URL for the so-called "Database Password Sleuth" is limited to "Access 95/97/2000/2002". Not sure why A2003 is omitted, but certainly A2007 is omitted because the database password encryption was strengthened big time in A2007. But I have heard that there's enough information stored in the file header to crack it. In my opinion, the database password serves no purpose whatsoever except to give people a completely false sense of security. – David W. Fenton Mar 01 '10 at 23:43