It may be as simple as setting one of the properties. I'm soory I shouldn't
be posting when I don't have all of the information, but if you were to
iterate through the properties of your linked table you will note that one
of them deals with the table be read-only. once that property is determine,
you simply need to set it to false or true prior to your append.
I would be interested in the code you are using since I am trying to do the
Thank-you and regards
> I am programmatically using ADOX to Append a Linked SQL Server 7.0 table
> a local Access 2000 database. That is working fine. However the table is
> linked in read-only mode! This is odd because manually linking the table
> using Access 2000 link table wizard works fine. Any one encounter this
> issue before?