manipulate cuser variable through code

[JACKSON]

Would anyone know if there is a way to manipulate the current user value through code. I have a database and have all users signing on via the Admin user (basically not activating the password on the Admin user). I have a form that does request a password and username, which I use to allow access to various forms, etc. I know I could have done this through access security, but I needed to add some specific rules on the sign in that cannot be done through the standard access security sign-in. I am then able to store the username given at sign in and use this to allow or disallow access to various forms. I can also track when people sign in and sign out using this method.

Anyway, what I would like to do know is be able to set the system currrent user cuser variable to the user name they signed in with , and my reason for this has more to do with possible record locking conflicts if everyone effectively signs in as admin.

Is there a way to change the cuser variable through code ??


Thanks
Jackson

 

[Dennisk]

as far as I know CurrentUser() will only return the current logged in user and there does not appear to be a counter part ie currentuser()=something

However you can open a workgroup file but whether it is possible to manipulate the data I don't know. you would have to experiment.

If you implement workgroup security there is nothing to stop you having an aditional file with further information on each user.