I'm writing a script to export a found set from DB1 to DB2. Found set in DB1 will be deleted after the export. The delete is the problem.

Many people use the database so a default password is used. Access privileges for the default password allow Browse, Print, Export, Create, and Edit. Only the administrator can delete records. DB1 and DB2 have the same access privileges.

I need the capability to have the user click on a button to export/delete the records. I have scripted a buttom to generate the found set, export the records, and delete the records in DB1. The script will not delete the records because the default password doesn't allow deletion of records. How can this be done?

Give all passwords access to all necessary commands and limit only the menu items displayed (set Available menu commands to 'Editing Only' or 'None'). Then you can script any commands needed and test group access using PatternCount( Status(CurrentGroups), "admin" ), etc.

Thanks for your help. Limiting the menu commands did the trick.