Hi Sally,
To foil "someone with enough knowledge" with Access is difficult. The best security you can get with Access requires using a back end like SQL Server or SQL Azure. You will need to use Stored Procedures in SQL Server or SQL Azure accessed by using ADODB or ODBC and unsaved Pass-through queries in code. Then you can save your front-end Access database as an accde or mde file and distribute it to your users. This type of security is normally done by experienced professional Access and SQL Server developers.
When Access is developed like this it can be an excellent and secure application. It will almost always be much less expensive than developing with NET.
For more information on Access Security see my articles:
How to Plug Microsoft Access accde and mde Security Leaks
http://accesstips.wordpress.com/2011/08/18/how-to-plug-microsoft-access-accde-and-mde-security-leaks/
Short Link: http://bit.ly/pbiGad
Although this article is about using SQL Azure most of it applies to SQL Server back ends as well.
Building Safer SQL Azure Cloud Applications with Microsoft Access
http://accesstips.wordpress.com/2010/10/12/building-safer-sql-azure-cloud-applications-with-microsoft-access/
Short Link: http://bit.ly/hnhC2q
Kind Regards,
Pat Wood, Access MVP
http://gainingaccess.net
--- In MS_Access_Professionals@yahoogroups.com, Sally Vega <sally_vega@...> wrote:
>
> Good morning all,
>
> Where I work we have a hyperlink through the intranet that will access the front end .accde version of Access for the user to access and run it.
>
> My problem is that someone with enough knowledge can still open up the tables and manipulate them. Is there a way to lock up the front end so that this can't happen?
>
> In the old version all you had to do was create an executable and that was it. I'm not seeing this in Access 2007. What am I missing?
>
> Thank you,
>
> Sally
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar