By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

security

P: n/a

Hello everyone,

This will be my first post and I'll be quick with it.

I have created a database and want to secure it from other users. I
still want them to have access to read the data. I don't know what I
did, but some how I managed to delete myself as an Admin. from my stand
alone. Everytime I try to run the Security Wizard, A diolog box pops up
an tells me this forbidden note... (You must be a member of the
administrators (Admins) group to run the Security Wizard and secure your
database.) And following is this wonderful OK button option. How can I,
as a user gain access again so that I can add other users? Your help is
appreciated in advance.

Thank You!
--
Posted via http://dbforums.com
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"phatnek" <me*********@dbforums.com> wrote in message
news:35****************@dbforums.com...

Hello everyone,

This will be my first post and I'll be quick with it.

I have created a database and want to secure it from other users. I
still want them to have access to read the data. I don't know what I
did, but some how I managed to delete myself as an Admin. from my stand
alone. Everytime I try to run the Security Wizard, A diolog box pops up
an tells me this forbidden note... (You must be a member of the
administrators (Admins) group to run the Security Wizard and secure your
database.) And following is this wonderful OK button option. How can I,
as a user gain access again so that I can add other users? Your help is
appreciated in advance.


Since almost no one applies security properly the first time they try,
there's a good chance that you have some back doors still open.

First, use the Workgroup Administrator Utility to rejoin the default,
non-secure workgroup file (system.mdw). This will either be in your
Windows system folder or in your Office folder. Once joined to that you
should find that you can open Access and create a new blank file without
being prompted for a login.

Then while in this new, blank file, go to File - Get External Date -
Import. Browse to your original file and see if it will let you see
objects for importing. If you do, just import all objects from every tab
available. If you have any import/export specs or custom menu/toolbars,
then click on the [Options] button and make sure the CheckBoxes are checked
to import those objects as well.

If everything imports, then you are back where you started.

Access security is not trivial. You need to get the FAQ document from MS
and read it thoroughly several times before trying this again (on a copy of
your file). You at least experienced the obvious mistake which is to
accidentally lock yourself out. What is far more common (and usually not
even noticed) is people thinking they have applied security, but have left
so many holes in it that it was a waste of time.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a

I followed the steps you indicated above, But I still can't create new
users. When I go to TOOLS - SECURITY and select User & Group Accounts,

I get the user and group accounts dialog box. Normaly this dialog
would have 3 tabs to select from (Users, Groups, & Change Logon
Password). On my unit I

only see Users & Change Logon Password tabs. Groups is missing. Another
funny thing is that in the users tab, My options for NEW, DELETE, &
CLEAR PASSWORD

buttons are shaded ( meaning, I can't do anything with them.) Another
funny thing is, when I access this datatabase on another system those
options are there.

Did I enbed a secret file that is only to my machine? Because when I
open a pre-existing database these options are also not available.
ARGHHHHHHH!!!

Thanks again!
--
Posted via http://dbforums.com
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.