I have been using simple tables to store user ID's & passwords and want to
move toward inherent Access DB security to prevent some clever user from
reading/manipulating the user/group tables manually. However, I now have the
disadvantage of having developed security-related needs ...

When I try to open my database, I get a Microsoft Access Error that says
"Microsoft Access can not find the security.mdw This file is needed for
startup.  Any Suggestions?

I am trying to link tables programatically from a password protected database.
Assuming the password is "fred" the connect fails with an "Invalid Password
Message" when I use any of the following:
tdf.Connect = ";DATABASE=" & strFileName

I have set up User Security and wish to rename the user.  Can I do this
without having to remove the User and then adding again?
Thanks

Is it possible, for the purposes of one function that requires administrative
permissions, to reset the current user to Admin, execute the function, and
then require the user to log in again?  
Many thanks in advance -- I don't post much but read a lot and the help on

I was referred to this newsgroup from microsoft.public.access, where I
started this topic:

Is there any kind of tracking tool I can put in an mdb to log when someone
deletes a row from a table, short of trapping the delete event in a form?
Thanks.

When I have verified User level security on a Main Computer and set the data
base up for networking on remotes, how do I get the remotes to point to the
new MDW file on these remotes?
Thanks for any wonderful assistance as is evident in the Newsgroup.

I'm trying to figure out how to tell my Access database  "For me - I
wanna access all objects.  For anyone else who opens it up - only forms
& reports".
I don't know how to create macros - so that way is out.  I think

I have finally managed to set up user security on my main Computer and would
like to know if I have to do exactly the same on each remote that is linked
to this data base?  I have linked the Main Data base on a remote to the
network, but when I start the data base, it goes ...

I have designed a data base which will be distributed to local Community
Groups.  Do I need to set up User Security levels at each Community Group, or
can I build this into the data base at point of design?
Thank You

I have set up security on my database, with permissions to various users, but
I now need to know who is logged in, and when. any ideas how i can do that?

Could anybody pls help me out with the above issue:
While opening an Access database, if we press and hold down the SHIFT key,
the database window will open irrespective of the Startup settings. Is there
a way to bypass the SHIFT key? ie if I dont want the database window to be

I am attempting to set up security using Joan Wild's procedure.  I have run
into a snag from the get-go.
When I Start/Run and type in wrkgadm.exe I get a message saying "Windows
cannot find ........"

Is it possible to retrict users to only view/edit a specific subset of
records within a database.  Example: Saleman Bob can only see orders
associated with his customers - he cannot see Saleman Terry's orders and
Terry cannot see his.