installable isam not found

Anonymous
2024-03-28T17:11:23+00:00

Hello,

I get the error when accessing an encrypted Access 2016 database via VBA - installable isam not found

The connection string is:

oConn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & _

database & ";Persist Security Info=False;Jet OLEDB: Database Password = " & password

If I switch off encryption in the database again, the call works perfectly:
oConn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & _
   database & ";Persist Security Info=False"

The encryption-type in Access ist "legacy"

What do i wrong?
Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2024-04-04T10:19:15+00:00

Hello,

Thank you very much, the tip with the space was crucial.

Now it's working

Thanks

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2024-04-05T02:45:14+00:00

    Thanks for your feedback.

    You are welcome.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-03-29T13:52:10+00:00

    Hi Robert,

    Thanks for posting in the community

    Since the situation you mentioned is related to VBA code, you can refer to this article: Office VBA support and feedback | Microsoft Docs to go to Stack Overflow by using the VBA tag, along with any other relevant tags as there are also many experienced engineers and experts in the forums there.

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites, or any support related to technology.

    At the same time, we will also keep this thread open, so other Community members and experts can also share their suggestions and inputs.

    Thank you for your cooperation and understanding!

    Sincerely,

    George | Microsoft Community Moderator

    Was this answer helpful?

    0 comments