madvalpreston
Technical User
Hi
I am using MySql as a backen and Access 2010 as a front end, which is working reasonably well.
I would like to have a username password log in for the databse, and the login name be registered as currentuser.
does anyone know how I can achieve this.
1. I have the table in mysql with ID, Username, position and passowrd fields. Is there a way to make passwords ******* within the table.
2. Does anyone know how I can make the prompt for surname and password happen when a user loads (I have tried the access way but that seems to require Access own user set up and ignores Mysql table)
Any ideas or good links to examples please
Thanks
I am using MySql as a backen and Access 2010 as a front end, which is working reasonably well.
I would like to have a username password log in for the databse, and the login name be registered as currentuser.
does anyone know how I can achieve this.
1. I have the table in mysql with ID, Username, position and passowrd fields. Is there a way to make passwords ******* within the table.
2. Does anyone know how I can make the prompt for surname and password happen when a user loads (I have tried the access way but that seems to require Access own user set up and ignores Mysql table)
Any ideas or good links to examples please
Thanks