Using Powershell to access and update MS Access Database

Posted on 2012-08-25
Last Modified: 2012-08-28

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.
Question by:KANEWONG
    1 Comment
    LVL 67

    Accepted Solution

    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

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This script checks a path to see if a folder exists. If the folder does exist you will get output "The folder has previously been created. No action taken" If not it will create the folder. Then adds one user modify permission to the folder. It …
    Set OWA language and time zone in Exchange for individuals, all users or per database.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now