Sally-
The entire reason they "deprecated" User-Level Security is it is easily broken
and doesn't interface with Windows at all. There isn't a good way.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Sally Vega
Sent: Monday, October 10, 2011 8:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Creating an executable in Access 2007
Hi John,
You say user-level security still available for old format files, what's a good
way to lock users out of Access 2007 tables?
Thanks,
Sally
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Friday, October 07, 2011 9:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Creating an executable in Access 2007
Sally-
Creating an "executable" version has never secured the file or the tables. Both
.mde (execute only in 2003 and earlier) and .accde (2007 and later) files "lock
down" the code, but you can still get to the tables. Perhaps you're thinking of
the User-Level Security feature that's still available for old format files, but
that was never real security.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From:
MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogr
oups.com>
[mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%4
0yahoogroups.com>] On Behalf Of Sally Vega
Sent: Friday, October 07, 2011 5:20 PM
To:
MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogr
oups.com>
Subject: [MS_AccessPros] Creating an executable in Access 2007
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]
------------------------------------
Yahoo! Groups Links
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]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar