User Login And Tracking

[kvarnerexpress 0]

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

[whafizi 0]

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

[rvalkass 5]

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://forums.xisto.com/no_longer_exists/
http://forums.xisto.com/no_longer_exists/

[imran 0]

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://forums.xisto.com/no_longer_exists/

http://forums.xisto.com/no_longer_exists/

160374[/snapback]

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://forums.xisto.com/no_longer_exists/

2 - http://www.4guysfromrolla.com/

3 - http://www.codeguru.com/

4 - http://www.4guysfromrolla.com/

 

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

[iGuest 3]

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

[bittr 0]

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

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: https://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.

[iGuest 3]

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

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

[k_nitin_r 8]

Hi!@rvalkassNo offense intended, but I disagree. For a person with Visual Basic for Application experience (the original poster who started this thread), I believe Visual Basic .NET is a better solution than PHP for developing web applications. There are tons of free .NET based applications available on CodePlex and Visual Basic .NET is as good a language as C# for developing web applications, since they use the same framework and have access to the same set of classes. The Microsoft .NET framework includes built-in functionality for authentication of users and user registration; the framework also has the user interface pre-built so all you need to do is place the control onto the page from the toolbox with a simple drag-and-drop operation.Visual Basic .NET uses the same syntax that Visual Basic 6 / Visual Basic for Applications has. You still declare variables with the DIM statement, though you have a setting to define if the compiler should enforce the requirement of declaring variables and even a setting to define if the developer would have to manually type-cast variables. With both options turned off, Visual Basic .NET would resemble the behavior of Visual Basic for Applications more closely. The FOR loop, the WHILE loop, and the DO loop have the same syntax but we have the additional FOREACH loop, which I believe did not exist in Visual Basic 6. Arrays are still defined in the same manner but we now have collection classes, which are a part of the .NET framework and are simpler to use than arrays. GOTO statements and labels are still supported but are strongly discouraged within the development community as they tend to create spaghetti code - the GOTO statements and the labels themselves are not of as much consequence as the developers who use them but due to the inability of novice developers to use them effectively and due to low readability of code after using the jumps within the source code, they ought to be replaced with function calls or loops, as appropriate.@kvarnerexpressIf you do have any questions or concerns about how to use Visual Basic .NET, please feel free to post to the forum and I or one of the other members of the forum will gladly help you out with any problems that you may encounter.