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 |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2007-05-04 : 06:07:27
|
| I am have created a test table in enterprise manager v8 and linked this table to an access database. I am able to append to the table from access but cant delete or update.Ive set the permission settings to allow the user to update and del so cant work out why this isnt working?ANyone got any ideas? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-04 : 09:22:14
|
| Got any error message? |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-05-04 : 10:57:06
|
| Do the tables have primary keys? Without those, you probably cannot delete or update because the server can't be sure what row you intend to modify.e4 d5 xd5 Nf6 |
|
|
|
|
|
|
Linking from Access