Re: Securing a Database with Linked tables to different mapped drives

Hi Coleen, just a few more comments:

"Coleen" <coleenholley@xxxxxxxxx> wrote in message
news:uR0ofrngFHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Immanuel :-)
>
> So as long as our
> Networks group does the nightly back-up I don't feel too uncomfortable
> having all the users access the same front-end copy. I do understand that
> this is not recommended, but I just don't see a practical solution, short
> of
> me going to each individual users desk and making a copy (which isn't
> really
> feasible)

You really really don't want users accessing your database over a WAN. Have
a look at
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
for alternatives.

....I just don't trust the users to do this for themselves. I think
> I will make a copy of the fe & be and experiment with securing it in a
> different Network location where it won't affect anyone. Once I have it
> working properly then I can try securing the original database (after
> making
> a good back-up of course!)

Good idea. It's fairly easy to secure the split database. I gather that
you have the frontend secured. If so, then use your desktop shortcut to
open it; that will ensure you are using the right mdw file. Then open the
backend (in the same session, don't close Access), and you can then secure
it.

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: How to secure a split db?
    ... before securing the database. ... Instead, secure it manually. ... >> extra/different steps when converting to MDE? ...
    (microsoft.public.access.security)
  • Re: Securing a Database with Linked tables to different mapped drives
    ... we do a nightly back-up of the entire Network drive (I've had to ... working properly then I can try securing the original database (after making ... >> secure the database, that's what it takes.... ...
    (microsoft.public.access.security)
  • Re: Security not clicking
    ... looked good until I copied the secured database to the network. ... Joan Wild wrote: ... When I rejoin the system mdw, ... split the database when it is secure or when it is not secure? ...
    (microsoft.public.access.security)
  • Re: Word 2007 Missing User Level Securitty - ARRRGGGGHHHH What were they thinking?
    ... File servers aren't secure? ... Access predates Windows security, ... database system has never been updated or kept current. ... the OS-based database server product, ...
    (microsoft.public.access.security)
  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)