(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")

Question

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

Answer 1

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.