I would like to use an access database to hold all registered users and apply authentication to my site using VB.Net.
Can you please assist me with a code to achieve this. The code that I managed to do uses hardcoded usernames and passwords. I have used select case which the application will test the credentials entered with the ones hardcoded and if a true condidtion exists the user will be redirected to the relevant page. This way does not work in our fast paced industry, hence I'm now trying to implement the use of access database.

Your assistance is greatly appreciated.
Thank you.

You might want to take a look at this- http://dotnet.tekyt.info/?p=31

I've done it using MySQL, for Access all you need to do is change the Connection String (I guess you know this already judging from your post)