FP2003: Unique UserName/Password Access to Online App

Hi:
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?

Thanks

Charlie
cepesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hhammashCommented:
Hi,
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.  

hhammash
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cepesAuthor Commented:
Thanks hhammash:
I'll start on this and I may get back to you once I get a little further.

Charlie
0
hhammashCommented:
You are welcome any time.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.