I have an ASP / VBScript application with an Access database where that allows users to register with a website. If the username they select is taken, I want my script to suggest an available username for them to try. My database contains these two usernames: "suzie", "suzie1" When a new user tries to register with username "suzie", I want my script to suggest using "suzie2". So far with my script, when I try to register with "suzie", it suggests using "suzie1", which is already in the database. Then, when I try to register with "suzie1", it suggests using "suzie11" instead of "suzie2". Attached are my database and full page source code. This script is located on lines 143-160 of my source code.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
Windows