R
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
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