Discussion:
object data to SQL Server tables
(too old to reply)
Anita Reutiman
2005-02-03 20:22:24 UTC
Permalink
I want to convert object data tables to SQL Server database links. I can
get to the point where I've converted the object data to a table, but if I
open the linked table, it is read only. I have the permissions set
correctly, and it works if I edit the data through the properties window,
only if I open to edit the data view for the table it is read only. Does
anyone have an idea of why this table is read only? I appreciate the help.
Anita Reutiman
2005-02-03 20:51:59 UTC
Permalink
Thank you for your quick response. However, my map options are set so that
the Open in Read-Only Mode is not checked and I still have this problem. I
have other tables in the database that were created through SQL server that
allow me to open them in edit mode. It is only tables that I create through
AutoCad by converting object data that will only allow me to open them in
read-only mode.

Any thoughts as to why this is occuring?
Map>Options>Data Source>Data Views>Open in Read Only Mode?
Scott
Post by Anita Reutiman
I want to convert object data tables to SQL Server database links. I can
get to the point where I've converted the object data to a table, but if I
open the linked table, it is read only. I have the permissions set
correctly, and it works if I edit the data through the properties window,
only if I open to edit the data view for the table it is read only.
Does
Post by Anita Reutiman
anyone have an idea of why this table is read only? I appreciate the
help.
LochDhu
2005-02-04 15:10:55 UTC
Permalink
Anita,

Sounds like a SQL Server issue.

Have you looked at the security/permissions of this table in Enterprise
Manager? I would make sure the permissions are the same as the tables that
are not read-only.

Scott
Post by Anita Reutiman
Thank you for your quick response. However, my map options are set so that
the Open in Read-Only Mode is not checked and I still have this problem.
I
Post by Anita Reutiman
have other tables in the database that were created through SQL server that
allow me to open them in edit mode. It is only tables that I create through
AutoCad by converting object data that will only allow me to open them in
read-only mode.
Any thoughts as to why this is occuring?
Map>Options>Data Source>Data Views>Open in Read Only Mode?
Scott
Post by Anita Reutiman
I want to convert object data tables to SQL Server database links. I
can
Post by Anita Reutiman
get to the point where I've converted the object data to a table, but
if
Post by Anita Reutiman
I
Post by Anita Reutiman
open the linked table, it is read only. I have the permissions set
correctly, and it works if I edit the data through the properties
window,
Post by Anita Reutiman
only if I open to edit the data view for the table it is read only.
Does
Post by Anita Reutiman
anyone have an idea of why this table is read only? I appreciate the
help.
LochDhu
2005-02-03 20:43:19 UTC
Permalink
Check your Map Options:

Map>Options>Data Source>Data Views>Open in Read Only Mode?

Scott
Post by Anita Reutiman
I want to convert object data tables to SQL Server database links. I can
get to the point where I've converted the object data to a table, but if I
open the linked table, it is read only. I have the permissions set
correctly, and it works if I edit the data through the properties window,
only if I open to edit the data view for the table it is read only. Does
anyone have an idea of why this table is read only? I appreciate the help.
Loading...