Very Computer

by **Craig Perso** » Wed, 13 Sep 2000 08:05:08

Hello,

I am programmatically using ADOX to Append a Linked SQL Server 7.0 table to
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?

Thanks,

Craig

by **mary chipma** » Thu, 14 Sep 2000 01:01:48

yes -- it plain old doesn't work. use DAO instead. if you need sample
code, write back i'll post some for you.

On Mon, 11 Sep 2000 16:05:08 -0700, "Craig Person"

>Hello,

>I am programmatically using ADOX to Append a Linked SQL Server 7.0 table to
>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?

>Thanks,

>Craig

by **Paul** » Thu, 14 Sep 2000 10:07:43

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

Paul

> Hello,

> I am programmatically using ADOX to Append a Linked SQL Server 7.0 table
to
> 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?

> Thanks,

> Craig

by **mary chipma** » Thu, 14 Sep 2000 21:07:49

as far as i know, it works fine with access tables. but SQL Server
tables come in read-only.

>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

>Paul

>> Hello,

>> I am programmatically using ADOX to Append a Linked SQL Server 7.0 table
>to
>> 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?

>> Thanks,

>> Craig

Very Computer

ADOX.Append Creates a Read-Only Linked Table to SQL Server 7.0

ADOX.Append Creates a Read-Only Linked Table to SQL Server 7.0

ADOX.Append Creates a Read-Only Linked Table to SQL Server 7.0

ADOX.Append Creates a Read-Only Linked Table to SQL Server 7.0

ADOX.Append Creates a Read-Only Linked Table to SQL Server 7.0