Using ADOX to update a Property does not work.

[genojoe]

Using ADOX to update a Property does not work.

I want to change the Access database for a linked table. My abridged code is:

Dim oCAT As ADOX.Catalog
oCAT = New ADOX.Catalog
oCAT.ActiveConn ection = goConnection
Dim t As ADOX.Table
Dim p As ADOX.Property

For Each t In oCAT.Tables
If t.Type = "LINK" Then
t.Properties("J et OLEDB:Link Datasource") = "C:\MyAccess.md b"
End If
Next t

When I write the code in Access 2003, it works fine. When I write this code
in VB.NET, I get an error message for this line: 't.Properties(. ....) =
"....."'
that says "Property Item is read-only". The line does not compile.

How can I change this property for a linked table from VB.NET??

[Paul Clement]

On Sun, 6 Mar 2005 03:39:02 -0800, "genojoe" <ge*****@discus sions.microsoft .com> wrote:

¤ Using ADOX to update a Property does not work.
¤
¤ I want to change the Access database for a linked table. My abridged code is:
¤
¤ Dim oCAT As ADOX.Catalog
¤ oCAT = New ADOX.Catalog
¤ oCAT.ActiveConn ection = goConnection
¤ Dim t As ADOX.Table
¤ Dim p As ADOX.Property
¤
¤ For Each t In oCAT.Tables
¤ If t.Type = "LINK" Then
¤ t.Properties("J et OLEDB:Link Datasource") = "C:\MyAccess.md b"
¤ End If
¤ Next t
¤
¤ When I write the code in Access 2003, it works fine. When I write this code
¤ in VB.NET, I get an error message for this line: 't.Properties(. ....) =
¤ "....."'
¤ that says "Property Item is read-only". The line does not compile.
¤
¤ How can I change this property for a linked table from VB.NET??

You need to specify the Value property:

t.Properties("J et OLEDB:Link Datasource").Va lue = "C:\MyAccess.md b"
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)

[genojoe]

It does work. My line of code needs to be:

t.Properties("J et OLEDB:Link Datasource").Va lue = "C:\MyAccess.md b"

With this change it worked fine.
"Paul Clement" wrote:

On Sun, 6 Mar 2005 03:39:02 -0800, "genojoe" <ge*****@discus sions.microsoft .com> wrote:

¤ Using ADOX to update a Property does not work.
¤
¤ I want to change the Access database for a linked table. My abridged code is:
¤
¤ Dim oCAT As ADOX.Catalog
¤ oCAT = New ADOX.Catalog
¤ oCAT.ActiveConn ection = goConnection
¤ Dim t As ADOX.Table
¤ Dim p As ADOX.Property
¤
¤ For Each t In oCAT.Tables
¤ If t.Type = "LINK" Then
¤ t.Properties("J et OLEDB:Link Datasource") = "C:\MyAccess.md b"
¤ End If
¤ Next t
¤
¤ When I write the code in Access 2003, it works fine. When I write this code
¤ in VB.NET, I get an error message for this line: 't.Properties(. ....) =
¤ "....."'
¤ that says "Property Item is read-only". The line does not compile.
¤
¤ How can I change this property for a linked table from VB.NET??

You need to specify the Value property:

t.Properties("J et OLEDB:Link Datasource").Va lue = "C:\MyAccess.md b"
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)