I am thinking to create a Powershell script which can let me do my jobs below.
1. Access to Active Directory for user logon authentication - when a powershell script runs, it prompt for user name and password then user enter her Active Directory account for authentication.
2. Let me add new record in MS Access database - I will have three tables in Access database to keep staff annual leave balance.
3. Let Human Resources manager to add annual leave record and update the balance.
I do not want to use any Visual Basic or Dephi because I do not have such compiler in office, so I think, the Powershell might able to help.
Do anyone know, can this work with Powershell? I know, I can use Powershell to access MS Access database but I am not use if it can do my job.