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 - 2002-04-15 : 14:33:36
|
| Hi - I have a table created in SQL Server DB from select into statement in a stored procedure called from access project.The problem I'm having is that this table is not'updateable' in Access. The connecting user is the owner, creator of the table. I've even granted update to public but it still wont update this table within Access. Does anybody have any ideas of what this mightbe ??Pete |
|
|
kaus
Posting Yak Master
179 Posts |
Posted - 2002-04-15 : 16:23:47
|
| Found Reason:Saw this on MSKnowledgebase 'When you edit an attached SQL Server table that does not have a unique index defined, Microsoft Access beeps and displays the following message on the status bar: This recordset is not updateable. This recordset is not updateable'When I added a Primary key to the table was able to edit the table. Now I have to get this primary key into the new table with the select into -- the table gets dropped and then re-created each time the stored procedure is runPete |
 |
|
|
|
|
|
update permission on select into created table