Hope I am posting this in the right forum. We have a database solution which has been converted to version 7 form version 6 and now being hosted under fm7 server advanced running IWP

. . It comprises of about 20 files. Using the new security feature we had to create a small database which will create and manage all the passwords and users across all the files. We have done this successfully.

If I login under "user x" password "xxx" this will open all the other databases under "user x" and password "xxx" From the main file after logging in we have a re-login script attached to a button which will relogin us in with a different user and password and a new priveledge set. USing this script we also relogin into all the other databases with this new user and password.

It seems that the relogin works as we have set fields to show us the new user and priveledge set but my data from relationships does not work anymore .. It's almost like it has re-logged in but the data cannot see across the relationships..

Running this in the client server mode and not running under iwp seems to work fine.. It's on the web where we have the problem.. Any help would be greatly appreciated..

Thanks

Stu

This is a problem with the way the IWP is handing the user login. If, via a script, you change the users password in a separate file, the user will lose their privileges to the related file.

The only way around this I've found is to use a single file with multiple tables.

I was afraid of that!!

Thanks for the input

Stu