Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
My linked table with ADOX is not updatable
Message
De
31/05/2001 14:26:45
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Access
Titre:
My linked table with ADOX is not updatable
Divers
Thread ID:
00513325
Message ID:
00513325
Vues:
45
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
Répondre
Fil
Voir

Click here to load this message in the networking platform