Admin user question

Create a duplicated view of what your data shows and give your admin access to it all and any data access and hide it from all other users.
You can control who see's the new table and instead of setting the option "see only your data and edit only your data" set it to Edit all data - for just this "admin table view"
Hope this helps

Setup dynamic permissionsin the security tab on asprunner . Then select add admin user. Once your website is setup with user table(username,userid,password- Table must be setup first). added for login. Build your output. Then login as admin and go toAdmin section, there you will see permissions tab. Under that section you see usergroup. Admin should be there as well as guest Now add group you want to give certain permissions to. To the right you will see all your tables . Notice admin tab and check boxes for all fields ex.edit,add CHECK ALL IN ADMIN MODE .TO RIGHT.Now admin has access to add,delete,edit, any table. Go back to other group and call as you like . check off the boxes you want the users group to have access. That's almost it.
Now go to the next tab Assign users to that groupand assign users to the groups that you have made. Edit your users in the next tab if necessary.
Don't forget to go back to security and pick what your users can do in each table(Advamced Tab) . You will see three choices. Pick a relational field like userid that is in both tables to use as your parameter for what records they can see in that table. That's really it . The Admin user will see all records as we checked the adminmode for all table fields in the admin area permissions.
This will work as long as you are not using AD . Not sure how Active Directory works as I am running ASPrunner regular edition and AD works with Enterprise Addition.