I'm using Access 2000 (9.0.3821 SR-1) under Windows 2000
MS Access Help tells you that in order to secure a database, you need to get rid of the default user "Admin", as otherwise anyone with a copy of Access can open the database.
I followed the steps in the help file and
- created a workgroup file
- created a new user "newadmin" and added it to the "Admins" group
- imported the database into a new one so the owner is now "newadmin"
I then opened the database and made sure that
- I'm using the right workgroup file and
- the current user is "newadmin"
When I try to delete "Admin" from User and Group Accounts, following message comes up:
"Cannot perform this operation"
Also, although "Admin" hasn't got any permissions whatsoever, the database can be opened and changed if a different workgroup file is being used.