Security of related files

[Chris Wood]

I have two related files - File A contains layouts with related fields and scripts performed by buttons; File B contains the data; the relationship is based on record numbers which are in both files.

On startup, File A also opens File B. The user then presses a "start" button that runs a scrip that finds all records and sorts them. With no passwords in effect everything works well. However, if I define a passwords in both files that limits the user to Browse, Print, Export and Edit then when File A opens and I press "Start", I get error message "your password does not permit you to use the current sort order and when I look at File B all the fields are filled with hatching. I can only get it working if I have no protection on fileB.

Can anyone help?

Chris

[LiveOak]

Which file are you opening first? Does it have a startup script to open the second file automatically? My guess is that the first file is opening with a password and the second file is not. Do you have "try default password" set?

-bd

[danjacoby]

Oak probably hit on it with the "default passwords" -- use the same password set for both files, and set the same default password for both files as well (you shouldn't need to do that last step, theoretically, since by opening file B via a script from file A the same password should be used, but it doesn't hurt).