Access Security

[Sedrick]

I am interested in the best approach to securing both the login and the data of an Access database. I have a few different questions, but for this thread I'll begin with the question of data encryption.

I understand that starting with Access 2007 the data can be encrypted for a database. In setting up a server with a database of encrypted data and a front-end on the local user's machine how secure is it when going across the network?

Is there a secure layer available (like SSL) between a local windows front-end client and a database stored on a server? Can the data going across the network be secured?

When does Access 2007 or Access 2010 unencrypt the data; on the server before it sends it or in the frontend after it has gone across the network encrypted?

Thanks!

[NeoPa]

As Access is only a pseudo FE/BE system, the answer is almost certainly that the data is encrypted until it reaches the Access client on your PC. Access BE databases are not processed by a remote system at all. Instead they are processed by the same Access application running the FE.