Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1048
  • Last Modified:

Using Powershell to access and update MS Access Database


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.
1 Solution
QlemoC++ DeveloperCommented:
If you ask me, you are better off by using MS Access and its integrated VBA capabilities. PowerShell is best for scripting automated processes, not interactive stuff. It isn't suited well for input, though you can build forms and use GUI components of .NET, but that can get painful. Access allows to build forms with data binding - directly accessing the DB, and do that very simple.
The AD authentication can be done there, too, almost the same way as in PowerShell.

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now