I am creating my first Access ADP with MS SQL server. All the apps before that I have created used Linked tables and wanted to give this a shot for performance boost.
I want to create a login screen when the application opens. No problem in creating this BUT I need to know how or where to send the user name and password to.
Previously when I did this, I created a users table (tbl_Users) and when each user logged in it appended a record to this table with the user credentials. I used my own table for user privelages and management instead of MySQL user management. I felt I had greater control of my users this way.
THe question is should I create my own users table as previous applications OR use the built in MSSQL managment? If the latter is best option how should I set up the LogIn screen?
Thanks in advance!