Inserting data to MS SQL 2005 using Access 2003 with subform

[Jiri Vesely]

I'm using SQL server 2005 and having problems entering data through form in
Access 2003, which contains subform.
When a user does not have a role db_owner, he can't insert the data. When I
try to insert the data in an identical database on SQL server 2000 it works.

If I enter data using form which does not contain subform there are no
problems.

The problem is probably with MS access.

I installed all the latest updates.

I need to insert the data from Access 2003 into SQL server 2005 using forms
with subforms with a user who's role is not db_owner. Is it possible? How?

 

[Tom van Stiphout]

On Fri, 7 Mar 2008 05:22:00 -0800, Jiri Vesely <Jiri
(e-mail address removed)> wrote:

I don't think it's an Access issue, because I bet you cannot login as
a user of the lower security level and add data to that table via
Management Studio or an Insert query either. Rather it's most likely
a sql server security issue and you need to grant your roles the
ability to do what they need to do (insert in this case).

One thing some people forget to do is use the "dbo." prefix to specify
the object owner.
insert into SomeTable (...)
is different from:
insert into dbo.SomeTable (...)

-Tom.