login system using an Access front end to mySQL

[pjh85]

Hi,

I am in the middle of creating a mySQL database which uses an Access front end mainly for the nice interface and reporting features. The problem i am having is creating a login system that uses a table within the mySQL database to authenticate users.

I am currently using a PHP login system for database access via a website which looks up values in a table called members to authenticate users. what i was hoping to do is use the same table for users to login locally.

I have searched the internet for an answer but i am struggling with what exactly to search for. Any help is appreciated

 

[HiTechCoach]

I am currently using a PHP login system for database access via a website which looks up values in a table called members to authenticate users. what i was hoping to do is use the same table for users to login locally.

That should be possible. You can convert the same process used in the PHP code to VBA code.

Also for Access examples, check the forum: Sample Databases