Removing Access 97 Users from Security file

[TC]

Type this code in the debug window (ctrl-g) and tell us what message you
get.

dbengine(0).users.delete "fred"

where "fred" is the username of the user that you want to delete.

HTH,
TC
(off for the day)

 

[rena]

I cannot remove individuals from my database. I am
prompted for my user name and password when I start the
database and log in as the Admin in the Admins group.
When I highlight a name to delete, the delete button
remains inactive. Any help would be greatly appreciated.
Thank you in advance.

 

[Greg Kraushaar]

Does Access think "Admin" is the owner of the database?

 

[Lynn Trapp]

Make sure that you are logging into the database as a user that is a member
of the Admins group.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[rena]

I investigated and found out that 'Admin' is not the
owner and doesn't have "Admins" rights either. I found
the owner and was able to remove the users. Thanks for
saving me hours of frustration.