Skip to main content
Question

How can I connect to and access an MS Access database that has a database password.

  • December 21, 2021
  • 2 replies
  • 118 views
P
Forum|alt.badge.img+1

I'm trying to connect to and access an MS Access database that has a password and I am getting the following error.  

 

592021-12-20 15:02:42 | COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.0 user lacks privilege or object not found: VIP

 

I can connect and access another MS Access database that is not password protected without any issues. For what it's worth, I can connect and access data in the password protected database from FME Workbench on my local PC, just not from FME Server. 

 

Thanks in advance for any suggestions.

    2 replies

    j.botterill
    Influencer
    Forum|alt.badge.img+37
    • j.botterillInfluencer
    • Influencer
    • May 12, 2022

    Using 2021.2.5 I was able to read password protected MS access.accdb from a feature reader. If I mis-entered the password:

    Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Engine Type=5;Data Source=C:\\Temp\\Database11.accdb;Jet OLEDB:Database Password=********'. Provider error `(-2147217843) Not a valid password.'

    When entered correctly... the feature type displayed successfully imagePublishing to FME server with the correct password, I was able to run workspace successfully reading in Table1

     

    Are you reading in all objects / tables in the 'feature types to read' image

    P
    Forum|alt.badge.img+1
    • pearsonkf
    • Author
    • May 12, 2022

    Thanks for letting me know about this! We are currently on version 2021.2.3, but I will test it out as soon as we upgrade to 2021.2.5 or later.

    Reply


    Helpful Members This Week

    Community Stats

    31,223
    Posts
    118,404
    Replies
    38,824
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.