Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MMansfield
Starting Member
1 Post |
 Posted - 2004-06-21 : 06:03:37
|
| SQL 7 DatabaseMS Access 2003, using Table Linking.One specific table once linked is coming across as read only, so I cannot update any records within it.I'm using the standard Linked Table Manager, using an ODBC Connection to connect to the SQL server with an account that has full dbo permissions on the table.I cannot find any reference within the SQL Table desin that states read only, I cannot determine why from the Access Side it is only allowing read only on this table...I'm hoping for a simple answer, like check x setting on the table to resolve it.Other tables within the database open in RW mode.Any ideas ?Thanks for replies,M. MansfieldSQL Noob |
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-06-21 : 07:45:08
|
| One thought, when you link to a table you have to set the primary key or it will show up as read only.Laura |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-21 : 08:35:48
|
| No chance that the "table" you are linking to is actually a VIEW is there?Kristen |
|
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-06-21 : 09:12:38
|
| I've linked views before and as long as I set the PK then it was find, it pretended it was a table.Laura |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-21 : 09:19:35
|
| Yes, a simple VIEW would be fine, but probably not one that JOINed other tables such that doing an INSERT or UPDATE to that VIEW was regarded by SQL as being ambiguous.Also if the VIEW is on a table that includes a COMPUTED column you will be able to UPDATE via the View, but not INSERTI don;t know Access but maybe it treats such scenarios as "read only" as a matter of courseKristen |
|
|
|
keithc1
Yak Posting Veteran
88 Posts |
Posted - 2004-06-21 : 09:27:21
|
| Sounds like permission issue on the access side, is there a need to have the same account that's accessing SQL side created on access side as well?Keithc MCSE MCSA |
|
|
|
|
|
|
|
|
Hopefully a simple question. SQL Connection.