My database is setup so that I use the employees name, i.e. userid as the login user name on the Login form.
I decided to try and prevent duplicates by using the userid + the employeeid number so it would always be unique.
Of course I know how to prevent duplicate employees but still the issue with the id being unique.
Ex: Dave1 as Dave with EmployeeID as number 1 . Concantenate to dave1
Is there a better approach?
Login form userid duplicates
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Login form userid duplicates
I assume that the Employee ID is unique, so why not use that as login name?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: Login form userid duplicates
Yes it is, but it is not very colorful. John Smith logs in as 12 but of course it would work. I think I have a handle on this now. Will post back if I run into a snag.
Thanks Hans and it's been a while.
Cheers
Thanks Hans and it's been a while.
Cheers