FP2003: Unique UserName/Password Access to Online App

Posted on 2006-04-07
Last Modified: 2013-12-24
I asked a variation of this question before.  I need to have an application for professional liability for architects and engineers placed on the web.  We would like to "invite" an architect to complete his/her application and then submit the data to us, our server.  The architect needs the ability to enter the blank or partially completed application several times and then click "submit".

I know FP must link to a database such as Access but how do I (can I?) create the user name and password system and the ability for the user to view their application multiple times?


Question by:cepes
    LVL 14

    Accepted Solution

    Yes Charlie of course.

    There is a quick way to do that using Access + DRW (Database Results Wizard).  But if you want more complicated and secure method you will need to use ASP.

    In the quick way you can have unique password and user name for each architect.

    1- You need to create an Access database
    2- You need to create a table for the username and passwords
    3- You need to create a table for the projects
    4- You need to create a form to login
    5- You need to create a validation page (checks the password+Username)
    6- You need to create a menu with option for entering and editing data

    You can search the internet for ready made solutions if you are interested.  The ready made solutions will solve your login problem,  but you still need to do some work of you own to tailor something that you need.

    In case you are interested in a way that involves steps to follow and very little programming,  please let me know in order to start the steps.  


    Author Comment

    Thanks hhammash:
    I'll start on this and I may get back to you once I get a little further.

    LVL 14

    Expert Comment

    You are welcome any time.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
    Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
    The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
    The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now