"Max" <maxy_100@yahoo.com> wrote in message
news:O18gPrPMHHA.5016@TK2MSFTNGP04.phx.gbl...
>
> No one else is accessing the table as the database system is not live yet.
> I tried SELECT, UPDATE and INSERT and they all work.
>
> Cheers,
> Max.
>
>
>
> "Joe Yong" <NO_jyong@SPAM_scalabilityexperts.com> wrote in message
> news:Ohe1dfPMHHA.3424@TK2MSFTNGP02.phx.gbl...
>> Check to ensure nobody else is accessing the table including the user
>> trying to perform the delete (open query in some other window).
>>
>>
>> joe.
>>
>> "Max" <maxy_100@yahoo.com> wrote in message
>> news:uYM5e2NMHHA.4196@TK2MSFTNGP03.phx.gbl...
>>>
>>> Hello,
>>>
>>> I have a couple of tables in a SQL Server 2005 database back end and I
>>> want to delete some records through a query from a MS Access 2003 front
>>> end. I get an error in MS Access saying "Could not delete from specified
>>> tables". There are multiple users of the back end and each one logs in
>>> to SQL Server using Windows Authentication. Each user has the
>>> db_datareader and db_datawriter permissions checked for the database
>>> role membership. SELECT queries work and I can see the contents of the
>>> tables but the DELETE query cannot run from MS Access. I have a feeling
>>> I need to set up more permissions. Does anyone know how to get this
>>> working?
>>>
>>> Cheers,
>>> Max.
>>>
>>