I am trying to create 2 types of user: 1. Admin, and 2. Normal users.
I can successfully set this up, but the problem is I find the admin user can't make structural changes to the database while one or more normal users are logged in. An error message is displayed saying that "admin user...." is logged in so you can't make the changes.
How do I stop the normal users from being identified as admin users... so that the admin user can make structural changes even if other users are logged in?
I am aware that my "admin user" and the users that access think are admin users are different (my naming problem).
Anyway, is it possible to change an access db structually while other users are using it? How?