A2k3 ADP + SQL2k - can't edit data when connected as dbo.

[I'mTryingToDevOverHere!]

Hi all!

I see this problem mentioned elsewhere but can find no resolution.

I have a database set up for DBO use only. This is a database for personal
use by one person, and will be so for the forseeable future. I am the DBO,
and he is me! Any need to set up additional users/roles would be total
overkill. [But speaking of overkill, I'll be whipping up a client in VB.Net
as soon as I send this message since A is stumping me! ]

I tried to log on using an Access 2k3 ADP, and I can retrieve data fine, but
can't edit/add.

I have no problem editing/adding data when using Enterprise Manager or
Visual Studio. In all cases, I am using integrated security.

This is SQL2k SP3a on Win2k SP4 by the way.

Any ideas?

Thanks!

 

[Sylvain Lafontaine]

Is it a single query only that is Read Only or if all the queries that you
have tried have the same problem?

And also, how are you trying to acces and edit your data under Access?

 

[ÀÒÁ]

Hi all!

I see this problem mentioned elsewhere but can find no resolution.

I have a database set up for DBO use only. This is a database for personal
use by one person, and will be so for the forseeable future. I am the DBO,
and he is me! Any need to set up additional users/roles would be total
overkill. [But speaking of overkill, I'll be whipping up a client in VB.Net
as soon as I send this message since A is stumping me! ]

I tried to log on using an Access 2k3 ADP, and I can retrieve data fine, but
can't edit/add.

I have no problem editing/adding data when using Enterprise Manager or
Visual Studio. In all cases, I am using integrated security.

This is SQL2k SP3a on Win2k SP4 by the way.

Any ideas?

Thanks!