Re: ODBC tables read only
This is a discussion on Re: ODBC tables read only within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> You need to specify the primary key or unique index when you link the tables. Without this information, the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:33 PM
| ||||
| ||||
 Re: ODBC tables read only You need to specify the primary key or unique index when you link the tables. Without this information, the data will be read only. -Sue On Tue, 28 Oct 2003 07:44:04 -0800, "Xiaowei" <anonymous@discussions.microsoft.com> wrote: >I have an Access database on a windows xp computer which >has linked ODBC tables from sql server. > >The Windows xp is in the same workgroup with the web >server which has SQL server installed. > >After I try to open the odbc table, it asks for login, I >use SQL Admin to log in. I find the ODBC tables are not >updatable, read-only. > >How can I make the table updatable? > >We are not in a domain enviroment. > >Thanks for any suggestions      |
Linear Mode
