Access 97: Allow Non-Administrator to Add Users/Change Passwords With Form

MS Office Access


  • 1. I can't access secure web sites
    I can go to just about any web page except ones where I have to enter personal data, i.e. credit card number. I can shop and place items in my cart, but, when I click on "Check Out" and I get a "Page can not be displayed" message. Help, help, help!!!
  • 2. Help! Outwar webpage pops up constantly
    I am on broadband. Even when I don't have my browser on, a web page called pops up about every 5 minutes. I have tried to block it, but to no avail. Anyone know anything about this? Thanks, Ojaiteach
  • 3. AllowBypassKey setting on MDE file
    I currently have a 'front end' .mdb file which has table links to the back end. Each time I change a form, for example, I create a new .mde file which I distribute to the users. I'd like to prevent users using the shift key to view the DB window in the .mde file, but don't want to set it as such in the master .mdb file as I need to use the shift key when going in to develop. Any ideas on how I can make AllowBypassKey specific to the .mde version of the database? Many thanks in advance. Simon.
  • 4. Security in general
    Hi. I've not done any work on securing my dbs (Access 2003) and I've read enough on this newsgroup to know that its not without its frustrations. Is there another simpler way? I currently have just one general password which all users use. None of them are experts, so I thought I could just use some simple way to stop them going into Design View. They wouldn't want to do any design work themselves and anyway, they wouldn't know how to take this off, so this would be secure enough until I learn enough about proper security. Can this be done? How about modifying the Toolbar available to them on startup? Thanks, Noel

Access 97: Allow Non-Administrator to Add Users/Change Passwords With Form

Postby Larry R Harrison Jr » Wed, 18 Feb 2004 14:56:33 GMT

I have an Access 97 secured database which the client will need to add users
etc to it periodically for certain permissions.

I have already secured it and now how to handle these permissions myself.
The idea is to make HER able to do it, yet for her not to be the full-blown
administrator of the database. She should be able to add a user, assign the
user to a given security group which already exists (she CAN'T create these
groups or change THEIR permissions), and change their passwords.

I have been successful at using DAO to create a form for this very purpose
in Access 2000 & XP databases (link to how:
 http://www.**--****.com/ )
but not sure if this can be done in Access 97 as it does not have DAO.



Re: Access 97: Allow Non-Administrator to Add Users/Change Passwords With Form

Postby rusty » Wed, 18 Feb 2004 20:46:00 GMT

Access97 does have DAO. What it doesn't have is ADO.

Peter Russell

Re: Access 97: Allow Non-Administrator to Add Users/Change Passwords With Form

Postby Larry R Harrison Jr » Wed, 18 Feb 2004 23:16:00 GMT

Silly me! How could I miss that!

I was able to import that form (which I made) into the 97 database easily
(after converting it to 97); only the thingie showing the path to the tables
doesn't work, all else works fine.

Silly me!


Similar Threads:

1.Office 97 Spellcheck unavailable in non-Administrators User?

I recently had to reload everything due to a power supply failure, the
reload was done on a clean / new hard drive.

I have everything working but am unable to get the spellcheck in Office 97
Professional to work in users that do not have administrators privleges. And
now I see that the spell check in the Oultook Express is not working either.
Any ideas??   the program works fine otherwise.
Thanks Jeff

2.How to allow users to change their password?

MS Access 2K, Windows XP

So, crossed the first hurdle of testing the security setup and splitting the 
secured database. Thanks, Joan, TC, David, Rick and others who patiently 
answered my questions over the past couple of weeks.

I have some more questions regarding password for a user (who only has 
permissions to use the Forms and not make any design changes to db objects).

How does a user change her/his password after I create the username? The way 
my database is set up, they won't be seeing the Tools option in the menu as I 
have the following unchecked - "Display database window", "Allow full menus", 
"Allow Built-in toolbars" and "Use Access Special Keys".

Does that mean all password change/reset request from users will have to go 
through the data admin? Meaning they tell me the new password, and I go in 
and set it for them? Also, please correct me if I'm wrong, but to _change_ a 
user's password for her/him, I'll have to login using their login 
name/password first.
Logged in as myself (with all the privileges), I can only _clear_ the 
password of another user, but cannot _change_ it. 

Is it OK for a data admin person to be privy to all passwords? 
The other option is that whenever someone needs to change her password, it 
will entail me making a trip to their desktop and logging in as them with the 
"shift" key pressed to make the Menu options visible.....which I'm not sure I 

Am I missing something here?? Is there a simpler way to do this?



3.allow users to change password

I am using the "user level security wizard " to set up usernames and 
passwords . but i like to enable users to change there passwords . is this 
facility available in access?(i dont have logon form)

4.Allow users to change their own password


I am quite new to working with a sercured database and have a question. I 
would like to allow my users to change their own passwords but since the 
Tools drop down option is not available to them due to my startup settings 
they cannot access the toolobar screen necessary to make this change. 

I was thinking of creating a Macro that used the SetMenuItem action to make 
only this toolbar selection available to the users. I would then trigger this 
Macro by linking it to the OnOpen Event on my Switchboard form. But I can't 
figure out the toolbars naming convention when attempting to set up the 
Macro. The Help key did not seem to help me.(I'm feeling really dumb right 
now so please be patient.)

Does anyone know what integer value I need to enter in the below fields to 
produce my desired results below? Or am I trying to use the SetMenuItem macro 
action incorrectly?

Menu Index: I would like to reference the Tools drop down.
Command Index: I would like to reference the Security Menu.
Subcommand Index: I would like to ungrey the User and Group Accounts option.

If this is not the most effective way to accomplish this task feel free to 
suggest an alternative solution.

Thanks so much for your help,


5.Trying to open Access 97 application with non-admin NT user

Does the standard NT user have read/write permissions on the directory 
housing the 97 database? Users will have to have these permissions ..

Scott McDaniel
InfoTrakker Software
"Philip Holder" < XXXX@XXXXX.COM > wrote in message 
news: XXXX@XXXXX.COM ...
> Hi,
> I downloaded an Access 97 application as an NT admin user, then switched 
> to
> a standard NT user, but couldn't open the application.  I get the error:
> "The MS Jet database engine cannot open the file C:\Program Files...It is
> already opened exclusively by another user or you need permission to view
> its data".
> Any ideas?
> Regards,
> Philip H

6. Password on database - allow users to open front-end w/o password

7. User with limited security cannot access a non-password protected database

8. Older Access 97 db that has user names and passwords

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 30 guest