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 |
|
kaus
Posting Yak Master
179 Posts |
 Posted - 2004-01-07 : 19:45:16
|
| I've got an access project where tables owned by the user defined in the connection between the access adp (access 2000) and SQL Server2000 database are locked from being edited or deleted within the access project. All the permissions seem ok when I check in SQL Server. Is there anything I should check within Access ??, or something I am missing ?? I really liked using the access projects in the past, but they sure seem to have a lot of quirks like this especially with permissionsThanksPete |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-07 : 21:12:36
|
| How exactly do you know "database are locked from being edited or deleted"?Those tables.. have they primary keys? |
 |
|
|
kaus
Posting Yak Master
179 Posts |
Posted - 2004-01-08 : 11:26:40
|
quote:
Originally posted by Stoad
How exactly do you know "database are locked from being edited or deleted"?Those tables.. have they primary keys?
They did not have primary keys -- tables used for reports -- when I added primary keys they were able to be edited etc.. Thanks a millionDo you know why this is ??Pete |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-08 : 12:22:34
|
| Oh.. Pete, of course I don't know technical details why it is so. |
|
|
|
|
|
|
Table Permission problem with Access Project