User Login And Tracking

know vba with MSAccess but need to create a web app of an MS Access App. I need to make it multi user with the user only being able to see and edit his own data. The db is quite simple and could have only a single table, but could divide into one main table with a couple of relational tables. I need the user to be able to login in and create his own password. I would want the user to have to validate (e-mail) simular to registering for this forum. I noticed that this forum is PHP driven. I thought that might be a better solution but a higher learning curve from vba to vb.net

Comment/Reply (w/o sign-up)

Why dont you try to use PHP + MySQL solution? I believe it is better for web apps

Comment/Reply (w/o sign-up)

I agree. For a web application, using PHP and a mySQL database is a lot better than vba or vb.net

There are lots of sites where you can find tutorials or pre-made scripts to download. Just download a pre-made login script and you are away!

Try having a look at some of these sites:

http://www.hotscripts.com/PHP/Scripts_and_...Authentication/
http://www.hot-php-scripts.com/php-script/...ogin_System.htm

Comment/Reply (w/o sign-up)

PHP and MySql might be good solution for web based applications but i dont think if somebody already knows VB he should try PHP. As far as free applications and script concerns even in ASP a lot free scripts and applications available. Agreed not as many as in PHP but more than enough for a beginner.

I suggest if you already know VB then develop your webiste in ASP and Access. For free scripts in ASP you can check these websites

1 - http://www.webwizguide.info/
2 - http://www.aspfaqs.com
3 - http://15seconds.com/
4 - http://www.4guysfromrolla.com

You can also search in google by typing FREE LOGIN SCRIPT IN ASP.

 

 

 

Comment/Reply (w/o sign-up)

A user logon and tracking script, which language to use?
User Login And Tracking

I would like to learn a language for creating or using scripts to allow users to be able to logon to their own personal account to use my site and allow me to view the date/time of which links are clicked so I can keep track of which user joined which sponser so I can reward them for doing so. Is this possible?

Thanks in advance :)

-question by David Almond

Comment/Reply (w/o sign-up)

Hi, David!
It's been awhile since your post here, but maybe you still track it somehow and you'll see my piece of advice.

Since you posted in the .NET forums, I'm going to give you some ASP.net suggestions. The big idea is: yes, it is possible what you have in mind, and actually it's not so hard.

1. For the user login, the easiest way to do it is by using a Login Control, like described here in the MSDN documentation: http://msdn.microsoft.com/en-us/library/ms178329.aspx
You don't need to write any code, you just add this control from the toolbar in Visual Studio to your website's masterpage, and it will automatically take care of your users' logon, authentication, etc.

2. About seeing the date/time and what links your clients clicked, you will need a bit of code (C# in my suggestions, but you can use VB.net also). You can make all the links on your website to be at design time LinkButton controls, not simple links. LinkButtons look exactly as normal links to the end-user, but the beauty is that you can attach events to them,and make some code execute on those events.
In your example, you can use the OnClicked event. When the user clicks a link, you'll add code that sees who it is (you will find information on how to do it in the link I provided above), you can use the event arguments to see what link he clicked on, and finally you can get the date/time they clicked with DateTime.Now(). After you'll get these 3 pieces of information (all you wanted) you store them in a database, and then you can check there your users' activity.

If you need more details, or help with some part of this process, post here and I'll gladly help you.

Comment/Reply (w/o sign-up)

I need to make it multi user with the user only being able to see and Edit his own data. The db is quite simple and could have only a single Table,

I am using PHP/MySql for the same purpose..Current, myl system allows everyone to access the database...Which I don't want...I want user to acess limited part of the database ...And make modifications in that part only...Similar for the other user..He will be able to modify his own part...

 Please anyone anyguideme on this

Comment/Reply (w/o sign-up)