Greetings! I have a two part question. Please let me know if it is OK to post in one shot or if it needs to be two separate questions.
Here is the question:
1. I have an interface written in Visual basic 6.0 with multiple fields. I am using MS Access database as a back end to retrieve and update data. I would like to have secure the access to the database via the interface. I have a table with user name and password (only two fields). How can achieve this from VB 6. I have looked into this help here >> http://support.microsoft.com/kb/163002
but I am having hard time understanding it. Also, please bear in mind that there will be multiple users opening the database via this windows application at the SAME time. So, it should not lock the database out to one user.
2. Assuming that the user is authenticated, he/she will make changes to the data table via the application. I would like to store a log of who the last user was that accessed the database and what changes and which table was updated. Is this possible in MS Access?