Security over a networked folder

[Rick]

John,


Are you still having trouble with this? I have some code
and ideas that can help you out and solve the issues you
are having. Once you get the security setup correctly,
which means you need to have each user open the database
through a specified icon... having a target such as the
following:


"C:\Program Files\MICROS~2
\OFFICE\MSACCESS.EXE" "\\CRPATLFNP03\BusCred\BABC Pipeline
Database\BABC_Pipeline.mdb" /wrkgrp "\\CRPATLFNP03
\BusCred\BABC Pipeline Database\SYSPIPELINE.MDW"


That's a lot of stuff in there, but I'll break it down
later. Also, Admin is a built in user that cannot be
deleted, so even if you think you deleted that user, you
didn't. The Admin user is a way of locking out everyone
to make sure they must enter the database through an
icon. Without security setup, everyone who enters the
database is "Admin" by default. You must have an Admin
password setup to start, which activates the security.
You setup your name without a password, and then put
yourself into the Admins group. By the way, I never use
the Security Wizard. You can learn more about it and have
more control over it if you do it manually. To make the
database owned by you, you just need to have the security
setup, then create new database from that database, then
import all your objects (then setup as much security on
the objects that you like). Also, you'll want to
eliminate the password for the Admin and remove Admin from
the Admins group. Then, you'll user "CurrentUser"
function to check the user upon opening the main menu, and
if that user is Admin, which would mean that the user did
not do through their icon, then you display a form as a
modal popup, which will inform the user that he or she
must enter through the icon. I can also help you set it
up so that the Shift key is disabled, as well as the F11
key to fully lock it down (although must users do not know
of these bypass options).

Anyway, that's kind of an overview, and not specifics to
go step by step. I'm pretty busy right now, so I don't
have the time to go through everything. However, send a
response and I'll check in tomorrow. Perhaps we can work
on it one piece at a time, and I will send you the code
that you need. Believe me, I can help you have this thing
secured with no time. Don't worry... and don't give up on
Access security over a network!!

Take care,


Rick

 

[Rick]

Hi, John!


I'm in Charlotte, NC, so the time zone is 5 hours behind
you I believe. Sorry it's taken awhile to get back to
you, but I've been swamped all day.

Is there a way you can call me, or perhaps deal with this
over the weekend? Or we could setup a chat or something.
I think we need to get a real-time discussion going so
that we can get a total grasp of your problem. We can
continue to do it this way, but since I'm so busy here
lately (and because of the time difference), it might take
a lot longer than it would if we discussed via chat or
phone. That's up to you... really depends on how quickly
you need this fixed.

Sorry I don't have much time to look at this right now.
We have a 3 day weekend here, so if I don't go anywhere
over the weekend, I'm sure we could knock this out. Are
you able to work from home or only at work?


Talk to you later,


Rick

 

[Lynn Trapp]

There are several things that the A2K security wizard may not do for you.
One is to remove all permissions from the Users Group. Either go to Jack
McDonald's website (listed in his response to you) or to mine and get a copy
of the Security FAQ from Microsoft. It will give you a detailed description
of what you need to do. There are 10 steps that you need to follow exactly.
Be sure you haven't missed one of them. I also have an outline of those 10
steps on the security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm