Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
My linked table with ADOX is not updatable
Message
From
31/05/2001 14:26:45
 
 
To
All
General information
Forum:
Visual Basic
Category:
Access
Title:
My linked table with ADOX is not updatable
Miscellaneous
Thread ID:
00513325
Message ID:
00513325
Views:
44
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
Map
View

Click here to load this message in the networking platform