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 |
|
Barbara
Starting Member
4 Posts |
 Posted - 2012-07-05 : 18:57:40
|
| Hi,I just upsized a Access 2010 .accdb file to SQL Server and now several of my queries are read-only. Just the tables were upsized.Thanks for any help,Barbara |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-05 : 21:53:40
|
| I am out very much of my league here, but for updating from Access you would need primary keys (or unique indexes) on the tables. Check if your read-only queries are trying to update tables that do not have primary keys. If so add a primary key. |
 |
|
|
Barbara
Starting Member
4 Posts |
Posted - 2012-07-06 : 20:20:13
|
| Thank you sunitabeck,You are absolutely correct. When I added the index to my queries, they became updateable!Barbara |
|
|
|
|
|
|
Access to SQL Server query