I was looking to make a site where people need to create an account, and log in to view the main pages. Is it easy, or do-able, to use msoft access to make a database where people are able to sign up with a username and password via my website?

Reply

I most strongly suggest to not use Microsoft Access. Secondly, I suggest using a simple php login script and a MySQL database to hold all of your data (usernames and passwords)

Reply

If you want a "learn-by-example" set of sources, may I suggest that you use your astahost's cpanel and install the phpbb forum, you will then see how they use php and a mysql database in order to let people create their accounts and then login using username and passwords.

Reply

Yes it is easy but i suggest to use MySql or Postgress instead, and also i agree with the others.

Best regards,

Reply

Not to mention I've had a HELL of a time trying to get my Access pages to come up properly in any browser other than Internet Explorer... Not to mention none of the intended client computers had Microsoft Office... this WAS at a workplace where I tend to avoid using pirated software...
I since converted their databases to XML which was at the time fairly easy... but that's to say.. this was probably like 5 years ago now...

In any case... I agree... PHP + MySQL is pretty slick... and of course, free : )

Reply

Yeah, in most cases it is much easier to do it with PHP and MySQL database, when working with Microsoft Access I remember I had difficulties, due to I am used to a little bit different SQL, of course with time it gets easier, but.. A login script can be available for free written in PHP and MySQL or I even think you can find one which is using a database directory and is storing everything into simple text files, it's not a bad idea if you don't have any access to MySQL database, nevertheless, it's very easy to get MySQL database these days.. You just need to google for it and install it or embed into your scripts/files ;D

Another alternative is to use password protected directories, with lots of users for it, it can be done with PHP by sending and checking the headers or with CPanel which does this by adding/modifying .htaccess files in that directory, but I don't like this way, usually there are problems logging off and it doesn't look as "cool" as done with a scripting/programming language and a database or a text file.

 

 

 

Reply

If you still want to use Access for your site check this topic Connecting Ms Access To Php Using Odbc which explains in a very simple way how to do it with Php, and if you want to start right now your login system, check out this simple tutorial: Creating a PHP Login Script, in this case, it uses Php, MySql and the PEAR:Db library.

Also i recommend you to search here at the forums, there are a lot of topics related to this, like the following ones:

• A Simple Checking & Validation PHP Script
• Need Help With A PHP - MySQL Registration Script
• How Do I Do Script Checking & Validation In PHP?
• Extremely Secure Authentication System

Best regards,

Reply

We just learned the basics of Microsoft Access in school and I have no idea of how it is used for other than organize information for companies. It isn't very flexible and is quite confusing to use. I think it is best suited for info that doesn't need to be "accessed" often as adding/editing records are easy enough, but for people logging on and off of it noone can seem to find anything like that.

I highly recommend using MySQL and PHP (or ASP + MSSQL if you are on Windows) and doing a database from there. That's what I use and that is what major companies use.

Reply

1. Create a table of Login names and associated passwords. This can easily be incorporated in a table of employees. We will assume this table to be called TblLogin, and the fields called "LoginName" and "Password". The field Password can have a "password" input mask for security. Or those 2 fields could be created in a separate table that can then be hidden.

2. Create a table called "TblLoginRecords" to keep track of passwords entered as well as errors. This table would have the following fields:

LogLoginName (text)
LogPasswordEntered (text)
LogProblem (Y/N)

3. Create a form named "frmLogin" with the table "TblLoginRecords" as record source.

4. On that form, create 2 textboxes with the LogLoginName, LogPasswordEntered fields as Control Source. Also create a check box with the field LogProblem. Change the Visible property of LogPasswordEntered to No.

5. Create a button labeled "CmdLogin" with the following code attached to its OnClick property:

On Error GoTo Err_CmdLogin_Click

If [LogLoginName] = DLookup("[LoginName]", "TblLogin", "[Password]=forms!frmlogin!LogPasswordEntered") Then

DoCmd.OpenForm "FrmPage1"

Else
Me!LogProblem = -1
DoCmd.Quit
End If

Forms!frmlogin.Visible = False

Exit_CmdLogin_Click:
Exit Sub

Note: i would just like to say that if you do use this is can be easily be bypassed if they really want to attack you. this will only stop people from making mistakes.

but basicly what this is doing is, when someone enters a username/password it opens the the TblLogin and checks the LoginName to see if the username they entered is in the database to begin with then if it is a matching username it will then check to see if the password matches. Thus creating a login form!

I hope this helped and feel free to correct me if i made any mistakes

Reply

Can you post more information about this??? I'm a bit interesting on how you could do it.

Best regards,

Reply