By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Access Security

P: 43
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!
Jan 4 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,308
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.
Jan 5 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.