Database User Name Displayed on Welcome Form

[Stoic]

Hi,
I have an Assess 2007 database with a user table. This table holds database user names and user passwords an entry permission to the database. I also have a welcome form that activates when user enters the database using either of the user names and user password in the user table. Now, I would like to display the database user name (NOT THE SYSTEM USER NAME] on the welcome form of the user that enters the database.
I do not currently have a code for this.
I will appreciate any assistance.
Thanks

[Rabbit]

You can either set a flag in the table of who the currently logged in user is or store it in a global variable in a form that will stay open the entire time but is hidden.

On a side note, how are you storing your username and passwords? That seems like a huge security risk to store it in Access. Anyone can get into the table and see or change everyone's passwords.

[Stoic]

@Rabbit
Thanks, the user table is hidden and has a security feature as well. For storing, I have two fields (userId and userpassword). Only the administrator has access to changing password and most of the functions are disabled.
Can you send me the process of flaging in a global variable; I am sure that would help. I was also wondering if it is possible run a code to lookup a username from the user table.
Thanks

[Rabbit]

Just be aware that any security you put in access can be undone by the user relatively easily.

process of flaging in a global variable

That wasn't what I suggested. I suggested two different methods. One was set a flag in the table of who the currently logged in user is. The other was store it in a global variable in a form that will stay open the entire time but is hidden.

I'm not sure which method you are asking about.

[Stoic]

@Rabbit
Thanks, I will try the flag.
Thanks

[NeoPa]

The flag is simply an extra field in the table. Typically this has a type of Yes/No or Number. This option relies on their only ever being one user of the database at any time.

From Access 2007 there is another option (Temporary Variables I believe they're called) which are session specific and probably suit your requirement better.

Other alternatives are to ensure the FE is only ever single user and has a local table which can store such information. This allows the BE to be multi-user without complications.

[Stoic]

Thanks guys, but your suggestions are not working.

[Rabbit]

Then you're doing something wrong. You need to show us what you did by posting your code so we can tell you where it's wrong.