Security

[matt]

I have several ADPs that work fine, but one in particular has some security
issues. When I try to add/edit records in any of the tables I can't because
apparently I don't have permission. The funny thing is, I don't see any
differences in how I've setup the security for this database vs. others. I
have tried both Windows and SQL users.

Does anyone know what the minimum SQL permissions needed for editing data in
Access? What database role is required? Specifically, what check boxes
need to be checked in the "Database User Properties" windows in SQL Server
Enterprise Manager?

Thanks in advance for any help,

Matt

 

[Sapphire]

Go to Roles in your Enterprise Managers.

Choose the role you are accessing the Sql server with
your adp. Example : "Public"

Click on "Permissions" and give Update, Insert , Select
and Exec permissions to any Stored procedure or tables
required. This should solve your permissions issue.

Hope this helps

 

[matt]

Sorry. That doesn't work with my database.

Go to Roles in your Enterprise Managers.

Choose the role you are accessing the Sql server with
your adp. Example : "Public"

Click on "Permissions" and give Update, Insert , Select
and Exec permissions to any Stored procedure or tables
required. This should solve your permissions issue.

Hope this helps

 

[Sylvain Lafontaine]

Then maybe a mixed of owners: try to see if the use of the dbo. prefix or of
any other user name is not different with this ADP. In particular, take a
look at the Data Outline window.

S. L.

 

[Sylvain Lafontaine]

Oups, sorry, in my previous message, I wanted to mean to look at the Record
Source Qualifier under the Data tab for the Current Form and not the Data
Outline View.

(Sorry for the mix up, but I was currently on a DAP page and my mind got
slipped).

S. L.