Log in

View Full Version : User Database with Microsoft Access ?



Jas
03-27-2007, 05:12 PM
I was checking out this site and upon reading some of the posts I was woundering:

How, if it is indeed possible, could you use Microsoft Access to give users a username, password, access level, ect. and search that information so that when they log into a subweb it finds them in that Access Database and lets them into the website (i.e. if they type "John Smith", "TestPass," it find John Smith and his password and his access level in the Access Database to give him entrance into the site). Is that possible, if so how could one go about it (I don't need the code, just what language should I use), and is there a way to make this secure?

If all of this is possible, this is no doubt my best bet for my next website project, which will contain TONS of subwebs and TONS of users (hopefully) who will have different permission levels.

Jas
03-31-2007, 12:53 AM
No one?

thetestingsite
03-31-2007, 12:58 AM
Sorry, didn't see this post before just now. Anyways, back to your question. You would want to use ASP to access the Access database. Not sure how you would go about doing it, but this is the language you need. I believe you could also use PHP if you have the mssql extension installed (and specified in the php.ini file). Other than that, not sure what else to tell you.

Hope this helps, nonetheless.

Jas
03-31-2007, 02:29 AM
Thanks yet again TheTestingSite!

I'll have to check out those suggestions.

Does anyone else know any more?