I'm setting up a view so someone using a specific SQL login and
password can view the returned recordset, but cannot see how the view
was developed in design view, or add additional fields that were not in
the original view. What permissions do I give them?
Re: Riddle me this error ADODB.Recordset (0x800A0E7A) ...Authenticating your users is fine, but when you're doing that, yes, it will ... not let anyone in who doesn't have permissions, well, since, that's what ... Does SQL Server need to know who is accessing your intranet?... need to pass that person's credentials for SQL login purposes.... (microsoft.public.inetserver.asp.general)
Re: Find Record Command Box ... This newsgroup is meant to be about tables and database design.... a SELECT query using the required ID Number, ... the data from the returned recordset.... (microsoft.public.access.tablesdbdesign)
Re: new project, existing data, opens read only ... I can't Insert or Update records.... > NT login, specific permissions to tables (insert, update, ... > new SQL login, default settings... > new SQL login, specific permissions to tables ... (microsoft.public.access.adp.sqlserver)
new project, existing data, opens read only ... I can't Insert or Update records.... NT login, default settings... NT login, specific permissions to tables (insert, update, ... new SQL login, specific permissions to tables ... (microsoft.public.access.adp.sqlserver)
