Re: open exclusive for back end design

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 09:57:44 -0500

jk wrote:

> i have a db which is split fe/be on a network folder.This db had a
> general password created through open exclusive but at the time of
> the split, the linking did not work untill i removed the password on
> the backend.It is sufficient to leave the fe with the general
> password but i would like to secure the be with user level security.I
> need to be careful since i already have quite a few users on this db
> so i have yet to try it out...please advise on the above since it
> seemed strange that a password would affect the linking manager.

If you want to go with the database password (very easy to crack, by the
way), you can open the backend and set the password. Then open the
frontend, and delete the links. Then use File, Get External Data, Link to
create the links again - this time you will be prompted for the backend
password, which will be saved with the links.

If you want to implement user level security on the backend, you can still
do so. Follow the steps outlined in the security FAQ. If you are going to
leave the frontend unsecured, then you likely will not want to create your
own groups for the backend. Just assign the limited rights you need to the
Users Group. You could even deny permission entirely on the backend tables,
and use RWOP (run with owner permissions) queries in the frontend. This
would mean securing the frontend as well.

Security FAQ
 http://support.microsoft.com/?id=207793

Security Whitepaper
 http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
 www.jmwild.com/AccessSecurity.htm 

-- 
Joan Wild
Microsoft Access MVP

Relevant Pages

  • Re: open exclusive for back end design
    ... >> password but i would like to secure the be with user level security.I ... you can open the backend and set the password. ... > frontend, and delete the links. ... > If you want to implement user level security on the backend, ...
    (microsoft.public.access.security)
  • Re: READ ONLY ON NETWORK
    ... database into two components: frontend and backend. ... what you want to apply for security is called User Level ...
    (microsoft.public.access.queries)
  • Re: How do I apply security to two dbs using the same secure mdw?
    ... > gone through and set security on the frontend so that the ... > database can't be accessed with the standard system.mdw ... > is can I give the backend database the same security ... Open your frontend and refresh the links to the backend, ...
    (microsoft.public.access.security)
  • Re: Design problem : security layers
    ... I'd like to reuse the Objects i write for the frontend in the backend, ... So for the moment what i do is having two packages, ... the credit sub-package will contain all that behaviour that ...
    (comp.lang.java.programmer)
  • Re: Compiler textbook available online
    ... Just had a glance over the Alvilda website. ... compiler about a year ago. ... AST (that would be generated by the frontend). ... descent on the backend side as well. ...
    (comp.compilers)