Deleting records in a database from another with 2 different security files

[mmadani]

I have a button that says clear data, and would like to give the user or an
ADMIN account the ability to clear the records .


Also when the routine clears each table I would like a message box to
display

clearing table " Table name" now

and display the new table name in the Msgbox text as it moves on.

Some code would be nice

Thanks

P.S: I was looking at the possibility to use something similar to the cmd
line syntax in a shortcut to access the security file for each database ,
because the admin account has no rights in each database. You know the
default admin account

Thanks

Mo