(My DataBase has a Password) And, How to change the properties of access fields with VB.Net,(At least the question that doesn't have an answer, comment "It's not possible")

Mansour_Dalir 2,036 Reputation points
2023-07-13T12:48:21.0033333+00:00

hi I have no problem without a password. But when I have a password, I get an error.

Message Could not find installable ISAM

I want to change the properties of the field by object (Microsoft Office 15.0 Access Database Engine Object Library). I had indicated wrongly. (Microsoft Access 15.0 Object Library). Anyway, I still couldn't open the database (with the password).

imports Microsoft.Office.Interop.Access.Dao
           'My Password : mansour
            Dim myDb As Database = dbeng.OpenDatabase("C:\MyBD.accdb", False, False, Connect:="mansour")' is Error . I do not know the setting of this part
            Dim tbDef As Microsoft.Office.Interop.Access.Dao.TableDef = myDb.TableDefs(txtTable.Text)
            Dim myField As Microsoft.Office.Interop.Access.Dao.Field = tbDef.Fields("col1")
            Dim myPro As Microsoft.Office.Interop.Access.Dao.Property = myField.CreateProperty("Caption", 10, "My Caption")
            myField.Properties.Append(myPro)

Which one should I use? For every change in the database . Yellow or red

ACCESS

Developer technologies | VB
Microsoft 365 and Office | Access | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff
    2023-07-14T02:35:34.4333333+00:00

    Hi @Mansour_Dalir ,

    Programmatic interactions using Microsoft.Office.Interop.Access.Dao require the appropriate version of the Access Database Engine (ACE Engine) to be installed on your system. Make sure that you have the correct Access database engine installed on your system to successfully use the Microsoft.Office.Interop.Access.Dao namespace.

    Microsoft Access 15.0 Object Library is primarily used to write code that interacts with Access applications, while the Microsoft Office 15.0 Access Database Engine Object Library is primarily used to connect to and manipulate Access databases from external applications.

    So you should use Microsoft Office 15.0 Access Database Engine Object Library.

    Best Regards.

    Jiachen Li


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.