General information
Title:
My linked table with ADOX is not updatable
Hello !!!
I have this little problem with a linked table in Access 2000,
i can't make any update or insert to this table.
I'm using ADOX and VBA to link a table to ACCESS
Dim catDb As New ADOX.Catalog
Dim tblLink As New ADOX.Table
tblLink.ParentCatalog = catDb
tblLink.Properties("Jet OLEDB:Table Hidden In Access") = True
tblLink.Properties("Jet OLEDB:Create Link") = True
tblLink.Properties("Jet OLEDB:Link Provider String").Value = MyDSNConnect
tblLink.Properties("Jet OLEDB:Remote Table Name").Value = MyTableNameToLink
'Link Table
catDb.Tables.Append tblLink
How can make it updatable ??
Tanks
L-A
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only