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 |
|
kbearhome
Starting Member
36 Posts |
 Posted - 2003-07-28 : 16:15:32
|
| I have an Access database linked to tables and views on SQL server. Once I was able to update the SQL tables with Access but the rest of the time, nothing happens. I have permissions and everything on the tables and views. What else needs to happen to allow editing through Access? (I'd love to know why it worked once - nothing changed.) Thanks |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-07-28 : 16:43:27
|
| Check to see if you have Key fields assigned to each table.JimUsers <> Logic |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-07-30 : 11:52:57
|
| May also want to check what login and subsequent permissions the DSN you used to link the tables in has====Paul |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-07-30 : 11:53:09
|
| May also want to check what login and subsequent permissions the DSN you used to link the tables in has====Paul |
|
|
|
kbearhome
Starting Member
36 Posts |
Posted - 2003-07-30 : 12:02:14
|
| All tables have keys. Login has permissions to insert/update/delete on the tables/views. Even logged in as SA and unable to edit.Since login is required through Access before opening a table/view, does the DSN still matter?Thanks |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-30 : 12:47:33
|
| Did you assign the virtual Indexes?When you make a link to a table, it asks you what the unique identifier is.I believe with out doing that (and every subsequent time you connect) you will not be able to update.I Googled virtual Index, but no joy..I read it in a 2 volume MS Access Developers hand guide...painfulBrett8-) |
|
|
|
kbearhome
Starting Member
36 Posts |
Posted - 2003-07-30 : 13:22:03
|
| That did it although it took me three tries at linking them to make it work. Several times I got a SQL syntax error so I deleted them and tried again and had to close and re-open Access.Thanks |
|
|
|
|
|
|
Updating SQL with Access